Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I set the name of a WorkSheet?
Oops! Cancel that. m_Mode was set to empty string at the time. It's working
now. - Joe Geretz - "Joseph Geretz" wrote in message ... From VB6, I'm adding a new worksheet: Set m_WorkSheet = m_WorkBook.Worksheets.Add Now I'd like to set the name of the newly added worksheet: m_WorkSheet.Name = m_Mode No dice! Is this a read-only property? How can I set this to my own custom value? Thanks for your help! Joseph Geretz |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
automatically appending newly added data on worksheet to a master list worksheet | Links and Linking in Excel | |||
Unable to Insert Worksheet/Move and copy worksheet Excel 2003 | Excel Worksheet Functions | |||
plot graph from multiple worksheet as embedded chart object on every worksheet | Charts and Charting in Excel | |||
plot graph from multiple worksheet as embedded chart object on every worksheet | Excel Worksheet Functions | |||
Upload multiple text files into 1 excel worksheet + put the filename as the first column in the worksheet | Excel Worksheet Functions |