View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Otto Moehrbach[_6_] Otto Moehrbach[_6_] is offline
external usenet poster
 
Posts: 201
Default 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