| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Insert named range problem
I want to be able to insert a named range using an A1 reference based on the
activecell using VBA. Based on Help, I tried the following code: With ActiveWorkbook .Names.Add Name:="Hold1", RefersTo:=RefersToLocal End With It does insert a name, but the range it refers to is #N/A. Is there a way to do this so that it actually refers to the cell (for example, =B45)? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Problem with link to named range | Excel Discussion (Misc queries) | |||
| Insert Named Range Into a Cell | Excel Worksheet Functions | |||
| Series Named Range Problem | Charts and Charting in Excel | |||
| Problem with Dynamic Named Range | Excel Worksheet Functions | |||
| external named range problem | Excel Discussion (Misc queries) | |||
Threaded Mode
