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

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---