View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
SGangs SGangs is offline
external usenet poster
 
Posts: 4
Default How to capture the Sheet name in a cell

I was creating a contents sheet with the sheet names (no. of sheets are
constant). Since the sheet name can be modified, i need to capture the sheet
name in real time mode.