View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Edwin Tam[_7_] Edwin Tam[_7_] is offline
external usenet poster
 
Posts: 94
Default Navigate to specific cell on specific worksheet

You can use a statement like this:
Activesheet.Range("A1").Select

If the sheet is not yet activated, you can try:
Activeworkbook.worksheets("Sheet1").activate
Activesheet.Range("A1").Select

Regards,
Edwin Tam

http://www.vonixx.com



"Bryan" wrote:

Hi -

What VBA code tells the cursor to focus on a specific cell in a specific
worksheet.

Basically, I have a macro, and I want the first line to navigate the cursor
to a specific cell before th rest of the macro runs.

Thanks!
Bryan