Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Refering to worksheet 'object' name

Status
Not open for further replies.

TTThio

Programmer
May 3, 2001
185
US
Hi folks,

could you help me with how to refer to a worksheet object name?

I see in the project explorer that Microsoft Excel Object has two names to refer, object name, and property name
exp.: SHEET1(sheet1).

Is it possible to set the object name (SHEET1) using code? So far I'm just able to set the 'sheet1'.name
It would be nice if I can always set the object and property name to refer to the same name always.

Thanks ahead,
Tin Tin
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top