View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
pancho[_11_] pancho[_11_] is offline
external usenet poster
 
Posts: 1
Default A simple question

try:
Worksheets("StatusAccounting").Cells(x, 8).select


Francisco Mariscal
fcomariscal at hotmail dot com


-----Original 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
.