Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
find a sheet by a cell
Maybe this:
Private Sub Workbook_Open() Sheets("Sheet1").Activate End Sub It needs to go in 'ThisWorkbook', object. Also, take a look at this: http://exceltip.com/st/Cell_Function..._Path/180.html Remember, you have to save your WB before the change becomes effective. Regards, Ryan--- -- RyGuy "John" wrote: In a workbook I want to find the workssheet that has a a particular name in cell C1, make it the active sheet and get the name(tab) of the sheet into a variable. Help JOhn |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I find a cell with vlookup formula on sheet | Excel Worksheet Functions | |||
Find Value of cell in another sheet | Excel Programming | |||
Find Same Cell... Different Sheet??? | Excel Discussion (Misc queries) | |||
How do i find the last cell range in a sheet | Excel Programming | |||
How to find first and last cell in a Sheet with an entry | Excel Programming |