| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using sheet reference instead of name
IN the VBE each sheet has a name that looks like "Sheet5(Data)"...
the sheet name is data, and I v=can refer to Sheets("Data"), How can I use the sheet5 bit - the sheet's 'VB Name'? Thanks M |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Using sheet reference instead of name
Use the index number such as
Msgbox Sheets(5).name If this post helps click Yes --------------- Jacob Skaria "Michelle" wrote: IN the VBE each sheet has a name that looks like "Sheet5(Data)"... the sheet name is data, and I v=can refer to Sheets("Data"), How can I use the sheet5 bit - the sheet's 'VB Name'? Thanks M |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Using sheet reference instead of name
Sheets(5)
"Michelle" wrote: IN the VBE each sheet has a name that looks like "Sheet5(Data)"... the sheet name is data, and I v=can refer to Sheets("Data"), How can I use the sheet5 bit - the sheet's 'VB Name'? Thanks M |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Using sheet reference instead of name
No guys, this is just theindex position of the sheet within the book and it
changes according to where the sheet comes in the book. I am looking for a way of refering to the sheet regardless of its name or position. Any ideas? M "Sam Wilson" wrote in message ... Sheets(5) "Michelle" wrote: IN the VBE each sheet has a name that looks like "Sheet5(Data)"... the sheet name is data, and I v=can refer to Sheets("Data"), How can I use the sheet5 bit - the sheet's 'VB Name'? Thanks M |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Using sheet reference instead of name
Ah,
..codename sub test dim ws as worksheet for each ws in activebook.worksheets msgbox ws.codename & " - " & ws.name next ws end sub "Michelle" wrote: No guys, this is just theindex position of the sheet within the book and it changes according to where the sheet comes in the book. I am looking for a way of refering to the sheet regardless of its name or position. Any ideas? M "Sam Wilson" wrote in message ... Sheets(5) "Michelle" wrote: IN the VBE each sheet has a name that looks like "Sheet5(Data)"... the sheet name is data, and I v=can refer to Sheets("Data"), How can I use the sheet5 bit - the sheet's 'VB Name'? Thanks M |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Loop for formula on one sheet with reference from another sheet | Excel Programming | |||
| Nesting a sheet name reference within a cell reference??? | Excel Discussion (Misc queries) | |||
| How To make a sheet reference Variable (eq: sum(sheet!D2:H2)) | Excel Discussion (Misc queries) | |||
| Changing sheet reference to cell reference | Excel Worksheet Functions | |||
| Relative Sheet Reference (Summary Sheet) | Excel Discussion (Misc queries) | |||
Hybrid Mode
