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: 11
Default Accessing Excel Sheet


Hello,
When I look under the Excel Objects in the VBA Project window, the
worksheets are listed are listed by sheet number with a name, e.g.,
Sheet1(Sheet1) or Sheet1(Bill) if I have named the first sheet Bill.

How can I select the sheet based on the Sheet1, not the name of the
sheet? Or can I? I want to be able to select the sheet even if the
name is changed by a user.

Thanks,

Bill


*** Sent via Developersdex http://www.developersdex.com ***
 
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
Accessing Other Sheet Tabs from within Excel Eric Excel Worksheet Functions 4 August 21st 09 06:20 PM
Problem seeing and accessing top of sheet egii Excel Discussion (Misc queries) 1 January 11th 07 02:52 AM
Accessing a non-active sheet from a userform Ken Loomis Excel Programming 2 October 5th 04 06:45 AM
Newbie question about accessing Excel sheet from the web Patrick[_10_] Excel Programming 0 August 10th 04 06:50 PM
Accessing a textbox on a sheet.... Cyril[_2_] Excel Programming 1 August 11th 03 06:37 PM


All times are GMT +1. The time now is 05:51 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"