Home |
Search |
Today's Posts |
#5
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
lastrow is a range in this instance, so it would return something like the
following: $A$1:$A$29 dimming lastrow as long and using this: lastrow = Cells(Rows.Count, "A").End(xlUp).Row will give you this: 29 -- Gary "cush" wrote in message ... Does this code actually give you a Row (as in LastRow) or does it return a verticle range in col A?? "Gary Keramidas" wrote: if i set a variable, for example Set LastRow = .Range(.Cells(1, "A"), .Cells(Rows.Count, "A").End(xlUp)) can i use debug.print or some other means to show me what lastrow actually contains? -- Gary |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
place output of several debug.print statements on the same line | Excel Programming | |||
Debug.Print "Test " vbCodeLineNumber & ": " & varName | Excel Programming | |||
debug.print range "full" address | Excel Programming | |||
Debug.Print in a WITH procedure? | Excel Programming | |||
Debug.Print | Excel Programming |