VBA Code for First EMPTY cell in column

[jms2553]

I found the code that will return the first non-empty cell, but can't find one for the first empty cell. I need to continually update data, and add it to different workbooks and sheets, at the end of the existing data. Any help will be greatly appreciated.

 

[gnaga]

Range("A65536").End(xlUp).Offset(1,0).Select

this will select the first empty cell from bottom row of the coloumn. you can manipulate this to suite for your purpose.

GNaga

 

[jms2553]

That worked great - thanks! One more question, I hope. When I'm filtering data, to copy and paste into another worksheet, occasionally I need to select everything but the header row and paste that data into the first empty cell of a differenct worksheet. This row (containing the information that is going to copied and pasted) is going to keep changing, so what might be Row 485 one day will be 845 the next.