Ok...I have used the following code to open a new workbook and go to a
spacific cell..it works fine to get to it..but is it possible to make
it open with that cell at the top? I have a frozen column headings so
not sure how to go about it..

Sub Macro2002047()
ChDir "N:\Storage list"
Workbooks.Open Filename:="N:\Storage list\Water and Sewer
details.xls"
Range("A106").Select
Windows("Water and Sewer details.xls").Activate
End Sub

I'm new to the macro world so please help...Ohh..it is Excel 2003 on
Windows XP if you need that...

Kris


--
krisrice
------------------------------------------------------------------------
krisrice's Profile: http://www.excelforum.com/member.php...o&userid=32450
View this thread: http://www.excelforum.com/showthread...hreadid=522237