LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 133
Default Sheet vs. Worksheets

I'm trying to avoid potential problems caused by the change of the name or
moving of my sheets. How can I refer to a sheet regardles its name or
position.
The VBA project explorer refers to sheets as Sheet1, Sheet2 and so on.
How can I do the same in my code?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
combining worksheets into one sheet JBeaucaire[_90_] Excel Worksheet Functions 0 February 4th 09 10:41 PM
list sheet 1 - same cell (eg A1) in a group of worksheets sheet Helen B Excel Worksheet Functions 2 February 10th 08 12:51 AM
Sum totals of 55 worksheets on Sheet 55? L. S. Martin Excel Worksheet Functions 3 August 27th 07 07:50 PM
Max Value Across Worksheets Returning Sheet Name [email protected] Excel Discussion (Misc queries) 2 June 13th 07 01:01 PM
re-order worksheets by sheet name Julia Chromicz Excel Programming 4 November 29th 04 11:03 PM


All times are GMT +1. The time now is 05:41 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"