Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Navigate to specific cell on specific worksheet
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Navigate to specific cell on specific worksheet
First, select the sheet in question
Sheets("NameOfSheet").Select Then, select thge cell in question. There are many ways to do this. The best method wil depend on your specific situation. Range("C5").Select 'selects cell c5 or cells(3,5).Select 'selects cell c5 If you need to select a specific cell but that cells location may not be known upfront, there are many many other slightly more complicated but more specific ways of selecting cells. Joran6 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Not allowing to continu unless a specific cell has specific answer | Excel Discussion (Misc queries) | |||
Link to specific cell in specific Excel file | Excel Discussion (Misc queries) | |||
Link from a specific Cell in Excel to a specific para. in Word | Excel Worksheet Functions | |||
Highlight a row if a specific cell is specific numbers/words | Excel Worksheet Functions | |||
How do I make a cell date specific to input a value on a specific. | Excel Discussion (Misc queries) |