Get sheet name given a cell
 

Excel 2003, WinXP
I need some help to help an OP.
Programmatically:
I setup an array of sheet names.
I group all the sheets in the array.
I activate one sheet and select one column.
I use Find to find a cell entry.
It is found and I set it to FoundCell.
Question:
How do I get the sheet name where FoundCell resides?
Thanks for your help. Otto

Get sheet name given a cell
 

Try with

MsgBox FoundCell.Worksheet.Name

or

MsgBox FoundCell.Parent.Name

--
Regards,

Juan Pablo González

"Otto Moehrbach" wrote in message
...
Excel 2003, WinXP
I need some help to help an OP.
Programmatically:
I setup an array of sheet names.
I group all the sheets in the array.
I activate one sheet and select one column.
I use Find to find a cell entry.
It is found and I set it to FoundCell.
Question:
How do I get the sheet name where FoundCell resides?
Thanks for your help. Otto

Get sheet name given a cell
 

Otto,

How about

Foundcell.Parent.Name

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Otto Moehrbach" wrote in message
...
Excel 2003, WinXP
I need some help to help an OP.
Programmatically:
I setup an array of sheet names.
I group all the sheets in the array.
I activate one sheet and select one column.
I use Find to find a cell entry.
It is found and I set it to FoundCell.
Question:
How do I get the sheet name where FoundCell resides?
Thanks for your help. Otto

Get sheet name given a cell
 

Otto,

Not sure. Not tested : FoundCell.Parent.Name

--
Regards,
Auk Ales

* Please reply to this newsgroup only *
* I will not react on unsolicited e-mails *

"Otto Moehrbach" wrote in message
...
Excel 2003, WinXP
I need some help to help an OP.
Programmatically:
I setup an array of sheet names.
I group all the sheets in the array.
I activate one sheet and select one column.
I use Find to find a cell entry.
It is found and I set it to FoundCell.
Question:
How do I get the sheet name where FoundCell resides?
Thanks for your help. Otto

Get sheet name given a cell
 

Juan, Bob, A.W.
Thanks for your help. That makes it easy. Otto
"Otto Moehrbach" wrote in message
...
Excel 2003, WinXP
I need some help to help an OP.
Programmatically:
I setup an array of sheet names.
I group all the sheets in the array.
I activate one sheet and select one column.
I use Find to find a cell entry.
It is found and I set it to FoundCell.
Question:
How do I get the sheet name where FoundCell resides?
Thanks for your help. Otto