Starting an excel file at a certain cell number?

  johnem 21:47 31 Jan 05
Locked

Hi gang, fresh from the success of the last piece of brilliant and speedy advice, I am going to ask for a little more help. Following on with my stocklist and index ect, is it possible to persuade excel to open up the file, not where the last highlighted cell was when it was saved or closed but to open up at my index, say cell b134. Any ideas? Thanks in advance.

  VoG II 21:55 31 Jan 05

Press ALT+F11 to open the Visual Basic Editor. Insert/Module. Type in the following code:

Sub Auto_Open

Application.Goto reference:=Workbooks("mybook.XLS").Worksheets("mysheet").Range("B134"), scroll:=True

End Sub

Change mybook and mysheet to suit.

  johnem 22:18 31 Jan 05

Thank you once again VoG™, just tried that and once I had corrected my typo's, it worked. I had to lower the default security setting to medium, but it is fine. I had hoped that you might be looking in, as I have read many of your excellant replies in the past. Thank you.

This thread is now locked and can not be replied to.

Intel Coffee Lake 8th-gen Core processors release date rumours

1995-2015: How technology has changed the world in 20 years

Framestore’s haunting post-WWII title sequence for new BBC series SS-GB

How to install MacOS Sierra on an older Mac: Get Sierra running on Macs & MacBooks from before 2009