| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA to rename sheet WITHIN Excel
Hi,
I'm looking to be able to rename a separate workbook within excel, in the same way as a range can be named using the line: ActiveWorkbook.Names.Add "ThisRange", RefersTo:=Selection This is so that formulae within an excel sheet can reference to the named sheet (depending on previously determined parameters, the named sheet could be one of a number of data sources), using COUNTIF etc functions. Many Thanks in Advance Mike |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do i rename a sheet if the rename tab is inactive? | Excel Worksheet Functions | |||
| rename sheet tabs in excel | Excel Discussion (Misc queries) | |||
| How to rename Excel Sheet with more characters? | Excel Discussion (Misc queries) | |||
| I cannot rename my excel sheet? | Excel Worksheet Functions | |||
| How can i trap the rename event of an excel sheet? | Excel Programming | |||
Threaded Mode
