VBA code to goto first empty cell on opening a workbook.

**tony0710** · 03-03-2009, 01:10 PM

Hi

Is it possible to have excel 2007 open a workbook, activate the first sheet "output" and activate the first empty cell in column A - ready for user input? i.e. I want my user to open workbook "EHB Stock" and automatically the first empty cell in column A of worksheet "output" is activated and ready for input.

The rest of my code is:

Please Login or Register  to view this content.

**shg** · 03-03-2009, 01:22 PM

In the ThisWorkbook module:

Please Login or Register  to view this content.

**tony0710** · 03-03-2009, 01:29 PM

Cheers SHG - it works a treat - marking thread as resloved.

VBA code to goto first empty cell on opening a workbook.

LinkBack

Thread Tools

Rate This Thread

Display

VBA code to goto first empty cell on opening a workbook.

Re: VBA code to goto first empty cell on opening a workbook.

Re: VBA code to goto first empty cell on opening a workbook.

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions