| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Insert Name reference to Active Cell in VBA
Excel 2000
For a VBA/Macro statement: ActiveWorkbook.Names.Add Name:="A" & ActiveCell.Offset(0, 3).Value, RefersToR1C1:="=Sheet1!R5C5" What is the syntax to change to "RefersTo[ActiveCell]" ? i.e., What is the code for the macro statement to make the active cell the cell to which the new Name is assigned? TIA Fred Holmes |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| using the active cell as a reference in a function | Excel Worksheet Functions | |||
| If active sheet and cell reference | Excel Programming | |||
| How to reference an active cell | New Users to Excel | |||
| Active row cell reference | Excel Worksheet Functions | |||
| Active Cell Reference | Excel Worksheet Functions | |||
Threaded Mode
