| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Worksheet Code Name question
I'm doing some copying and pasting into a PowerPoint presentation and have a
problem with the following: Set XLSheet = XLBook.Sheets(sName) and I get an error on only one value of sName. I have sName dimensioned as a string. What I want sName to be is the sheet code name, but I think it's behaving like the actual sheet name. What do I need to change in this code so that it sees sName as the code name and not the sheetname? Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to prevent code running when in a worksheet code | Excel Programming | |||
| Code Conflicts With Worksheet Change Code | Excel Programming | |||
| Create a newworksheet with VBA code and put VBA code in the new worksheet module | Excel Programming | |||
| Altering code to reference the worksheet before the active worksheet | Excel Programming | |||
| Return to previous worksheet after code pastes in another worksheet? | Excel Programming | |||
Threaded Mode
