| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sheet CodeNames
Hi,
If I am using a worksheet codename, how would I use it in this formula? Range("A10").Select ActivateCell.formulaR1C1 = "='Mainsheet'!R10C22" The sheet's code name is MainPage. I have tried leaving out the single quotes i.e. ActivateCell.FormulaR1C1 = "=MainPage!R10C22" but it doesn't work. How would I use a sheet code name in this instance? Thanks for your help. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Loops with sheet codenames | Excel Discussion (Misc queries) | |||
| codenames | Excel Programming | |||
| Codenames | Excel Programming | |||
| Use of Sheet CodeNames to Select Sheet in Different Workbook | Excel Programming | |||
| Use Sheet CodeNames to Select Sheet in Different Workbook | Excel Discussion (Misc queries) | |||
Threaded Mode
