going to a cell

[Jean-Paul De Winter]

Hi,
when I open a file I would like to jump to a certain cell other then
A1... also jumping from one worksheet to another should bring me to a
cell like D7 instead of A1
how can I do this??
Thanks
JP

 

[Frank Kabel]

Hi
this would be only possible with VBA (using an event procedure). See
http://www.cpearson.com/excel/events.htm
for some informatiuon about this

Do you really want to go this way?

 

[Guest]

If you are trying to do it automatically, you'll have to have one of the VBA people help you. But if your looking to open a file and decide you want to manually jump down to cell A3232, then hit F5 and type in A3232 where it says reference. If you want to jump to Sheet 2, then type in Sheet2!A3232

I barely know what I'm talking about on VBA but the automatic option has something to do with:

Sub Auto_Open()


----- Frank Kabel wrote: -----

Hi
this would be only possible with VBA (using an event procedure). See
http://www.cpearson.com/excel/events.htm
for some informatiuon about this

Do you really want to go this way?

 

[Dave Peterson]

option explicit
sub auto_open()
application.goto worksheets("sheet1").range("d2"), scroll:=true
end sub

is one way to finish that routine.