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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
find a sheet by a cell
=MID(CELL("filename"),FIND("]",CELL("filename"))+1,255)
that's the formula offered in the "Look at this" you offered. It makes no sense to me. What does "filename" refer to? What is the "]" for? I want to find where the string "John G" is in a workbook and then save the name of the worksheet and the location of the cell. What has that got to do with the formula above? I found this formula before and it just baffled me. I've never seen an example of it's use... only the formula. Thanks John ryguy7272 wrote: 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--- |
Reply |
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 |