Johann

row named DayColumn ? Row ? Column ??

Anyway ...

Dim LastRow As Long
Range("B65536").End(xlUp).Offset(1,0).Row

Regards

Trevor


"johann" wrote in message
...
I have a macro which refresh a web query in sheet Quotes,
and copy/paste these values in Data. how would you
suggest a better way to have macro paste values in the
last non-blank cell? I am using a row named DayColumn
(B2) to tell macro what column to paste values.

Thanks