| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Define Name in active cell
Hi,
I try to define names in some cells. However, when I add data and sort the workbook, the Defined names are moved. In the sample below, the defined name will always be at Row 17 Column 4. How can I reference to the "Defined Name" alone? Thanks Range("D17").Select ActiveWorkbook.Names.Add Name:="nmnm", RefersToR1C1:="=Sheet1!R17C4" |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Active Cell displayed in another cell? | Excel Discussion (Misc queries) | |||
| How I can set highlighted active cell in row & colmun cross | Excel Discussion (Misc queries) | |||
| Woorksheet locked on active cell | Excel Worksheet Functions | |||
| How do I have an active cell highlight automatically | Excel Discussion (Misc queries) | |||
| Highlight Active Cell...With a Diffrence | Excel Discussion (Misc queries) | |||
Hybrid Mode
