| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Worksheet name as a variable in VBA
When you replaced '21-May' with strName, did you include the apostrophes? In a formula the '21-May' is a reference to a tab, and the value in cell c2 likely does not include apostrophes. Excel rejects the formula written by VBA if the apostrophes are not present.
|
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Link variable data from one worksheet to another worksheet? | New Users to Excel | |||
| Variable worksheet name (tab) linked to cell in same worksheet | Excel Worksheet Functions | |||
| Looking up a variable in one worksheet and copying information from another column to another worksheet?? | Excel Discussion (Misc queries) | |||
| Use a variable for a worksheet name? | Excel Programming | |||
| Assigning worksheet to worksheet variable | Excel Programming | |||
Threaded Mode
