| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
making a different sheet active
On the currently active sheet cell F2 has the name of the sheet I want to
make active. How do I activate this sheet? thanks, ck |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
making a different sheet active
you can try this
worksheets(range("F2").Value).activate -- Gary "Charlie" wrote in message ... On the currently active sheet cell F2 has the name of the sheet I want to make active. How do I activate this sheet? thanks, ck |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
making a different sheet active
This should do what you asked...
Worksheets(Range("F2").Value).Activate Rick "Charlie" wrote in message ... On the currently active sheet cell F2 has the name of the sheet I want to make active. How do I activate this sheet? thanks, ck |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
making a different sheet active
on error resume next
activeworkbook.worksheets(activesheet.range("F2"). value).select if err.number < 0 then beep end if on error goto 0 Charlie wrote: On the currently active sheet cell F2 has the name of the sheet I want to make active. How do I activate this sheet? thanks, ck -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding a new Sheet but not making it the Active Sheet | Excel Programming | |||
| Copy from active sheet and paste into new sheet using info from cell in active | Excel Programming | |||
| Making an open workbook active | Excel Programming | |||
| Summing a range without making it active | Excel Programming | |||
| Making an active cell the first one to appear on the spreadsheet | Excel Programming | |||
Hybrid Mode
