Tech Support Guy banner
Status
Not open for further replies.
1 - 2 of 2 Posts

·
Registered
Joined
·
3 Posts
Discussion Starter · #1 ·
My Excel spreadsheet is called open by a Word mail merge document.

The document finds it's data with no problem, but when I need to check or change the spreadsheet data, I find that it is always parked at cell Z47, well out of the "active area" of my data.

At this point, my "active area" contains columns A thru S, and rows 2 through 32.
I would like to know if there is a way to have the spreadsheet wake up to a specific location, like cell A1?
 

·
Registered
Joined
·
563 Posts
hi camtech,

was Z47 the active cell at the time the s/s was saved?
if so that's why it is parked at that cell whenever you open it (by 'parked' I presume you mean that is the selected cell / cursor position).

If not, then there is more to this.

You could force a 'wake up' at a specific cell with a simple macro :

Worksheets("mysheetname").Activate
Worksheets("mysheetname").Range("A1").Activate

Replace mysheetname with the name of you sheet [with the quotes], and place the macro in the THISWORKBOOK / OPEN event within the THISWORKBOOK Module.

or record something similar via Tools / Macro / Record New Macro

lol
Hew
 
1 - 2 of 2 Posts
Status
Not open for further replies.
Top