Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
A simple question
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IF formula-simple question; simple operator | Excel Discussion (Misc queries) | |||
simple Question | New Users to Excel | |||
Simple Simple Excel usage question | Excel Discussion (Misc queries) | |||
Simple Question | Excel Programming | |||
Simple Question | Excel Programming |