View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Paul Pedersen Paul Pedersen is offline
external usenet poster
 
Posts: 18
Default unchanging worksheet reference

Is there a way to refer to a worksheet other than by index or name?
Something that won't change as long as the worksheet exists.

Worksheets(1) or Worksheets("some sheet name") will no longer be valid if
someone inserts another worksheet before this one, or changes this one's
name. I'd like to be able to refer to a particular worksheet even if its
name or position in the workbook changes.