Solved: Selecting First Empty Cell in Column A

[enrique63]

What VBA code would I use to select/activate the first empty cell in column A of Sheet1 upon opening the workbook?

I'm importing data from Outlook, where it opens the workbook automatically, and want the new data added at the bottom intead of overwriting the data already there.

Thanks!

[jproffer]

LastRow = Range("A" & Rows.Count).End(xlUp).Row + 1

then


Sheets("SheetName").Range("A" & LastRow).Paste...or whatever...selecting and activating isn't really necessary, but whatever you want to do :)

[enrique63]

Thank you!