ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   A simple question (https://www.excelbanter.com/excel-programming/272685-simple-question.html)

pancho[_11_]

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
.



All times are GMT +1. The time now is 02:45 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com