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.
|