| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Named Reference
Hi,
Can someone tell me what the pros and cons are (if any) of these 2 ways of naming a range. ActiveWorkbook.Names.Add NAME:="HOME", RefersTo:=ActiveCell Range("HOME").Select or Dim HOME As Range Set HOME = ActiveCell HOME.Select Thanks, DaveU |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Maintaining cell reference after sorting | Excel Discussion (Misc queries) | |||
| Changing named range reference depending on a cell's content | Excel Discussion (Misc queries) | |||
| Using a formula to create named range reference | Excel Worksheet Functions | |||
| How to dynamically reference a dynamic named range | Excel Worksheet Functions | |||
| 3 cells are named - how to refere to them in one reference field in a chart | Charts and Charting in Excel | |||
Threaded Mode
