Thread: Sheet Position
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
James Weaver James Weaver is offline
external usenet poster
 
Posts: 7
Default Sheet Position

I know that code can be written to reference sheets
according to their position in the Workbook, e.g.:

Sheets("abc").Copy Befo=Sheets(6)

The sheet that is in position 6 is called "End" but it
moves position as you copy more sheets into the file! So,
I need some code to be able to locate the numerical
position of the "End" sheet and put the variable back into
the 'copy' code above.

Any ideas anyone?!

Thanks,
James