So do you want the first blank line in column A??? If that is the case then
something like this

with sheets("Sheet1")
..select
..cells(rows.count, "A").end(xlUp).offset(1,0).select
end with
--
HTH...

Jim Thomlinson


"pama" wrote:

I am a beginner and would like to create a macro that inserts an address into
a worksheet. It works fine if I am in cell A1, because the code calls up
cells A2 and A3 with: Range("A2").Select or Range("A3").Select.
What code do I use to make the next line of the address go to the cell under
the first line of the address no matter where I am on the spreadsheet. I hope
that makes sense.
Thank you.