go to first empty row
The code
Range("A65536").End(xlUp).Offset(1, 0).Address
will give you the address of the first cell in Column A that is blank.
If there are no blank rows between rows that contain data, this may
give you what you need. If you want to check to see if the entire row
is blank, that is slightly more involved. Will something like the
above work for your purposes?
Mark
geebee wrote:
hi,
I am writing code to copy data from another sheet and paste it into the
first new empty row in another worksheet. The problem is I dont know how to
go to the first available empty row in the new worksheet, to avoid
overwriting data that is already there.
Can someone help me with this?
Thanks in advance,
geebee
|