| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copy rows from one Data sheet to another sheet based on cell conte | Excel Discussion (Misc queries) | |||
| How do I copying data from a cell on sheet to a diff cell/sheet | Excel Worksheet Functions | |||
| copy a sum in cell on sheet 1 (not formula) to cell on sheet 2 | Excel Worksheet Functions | |||
| copy a sum in cell on sheet 1 (not formula) to cell on sheet 2 | Excel Worksheet Functions | |||
| Excell:Move from any Cell Sheet 1 to any cell Sheet 2 etc. | Excel Worksheet Functions | |||
![Otto Moehrbach[_6_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
