View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Gary Keramidas[_4_] Gary Keramidas[_4_] is offline
external usenet poster
 
Posts: 226
Default question about debug.print

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