Hi
This code will select the first empty cell in column A
Change the A65536 to B65536 if your data is in column B
If you want this done automatically then use the auto_open macro.
Installing the macro:
Click on the developer tab
Click Record Macro
Click on this worksheet then ok
Click on any cell
Click on the developer tab
Click Stop Recording
Click on the developer tab
Click Macro
Select your macro then click on edit.
Paste my code over the code that you see
Close the window
Save the Workbook as a macro enabled workbook.
Enjoy
Bookmarks