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
|