Private Sub Workbook_Open()
Dim x As Long
x = 3 ' for testing
Application.Goto Worksheets("StatusAccounting").Cells(x, 8), scroll:=True
End Sub

Place this in the Thisworkbook module

--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
www.rondebruin.nl



"Kirk" wrote in message ...
For some reason I can seem to figure this out. I know it
is easy, but I'll ask anyways.

I need to be able to go to a specific cell when I open up
my workbook.

I tried this:

Worksheets("StatusAccounting").Cells(x, 8).Activate

where x is a looping variable to go through each of the
cells. But it didn't like it. I'm using XL2002 SP2.

Any help would be appreciated.

Kirk