Hi i'm new in VBA can you please explain why my debug.print give error? Thank you
Sub Macro1()
Dim ws As Worksheet
i = Worksheets.Count
Set ws = Worksheets(i)
Debug.Print ws
End Sub
1 Answer
You can't print the worksheet object (ws). You can print some of it's properties e.g. it's name. Also, put Option Explicit at the top of your module and declare i.
You can use Debug.Print to write out information, to help with debugging, to the immediate window. The immediate window can be opened with Ctrl + G.
You can gain the same information by putting ? in the immediate window before the same code line e.g. ?ws.Name (provided your code has been halted during execution, example, with STOP keyword, and has retained the required value)
Option Explicit
Sub Macro1()
Dim ws As Worksheet
Dim i As Long
i = Worksheets.Count
Set ws = Worksheets(i)
Debug.Print ws.Name
End Sub
18 Comments
Shai Rado
LOL, typed it in at the same second
QHarr
:-) OMG.... for once, I shall just savour this moment, I got answer in before The Rado! You must have been multi-tasking!
TooMacho BA
@QHarr So how debug.print even work how should i use it? And ty for answer
QHarr
And this gives much more info msdn.microsoft.com/en-us/library/aa716276(v=vs.60).aspx
TooMacho BA
@QHarr Thank you for your time :) please don't delete any of your comments i would like o save the sites when i get home :)
|
Debug.Print ws.Name