| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro Recording
Can anyone explain why when I record a macro which names a range, the macro
records ActiveWorkbook.Names.Add Name:="New NamedRange", RefersToR1C1:= _ "='Cricket Shirts'!R1C1:R26C5" I am not aware of any setting that tells it to record in RowColumn notation, I certainly do not have that option ticked in Options | General. Can anyone explain why the address of the range is not in normal alpha numeric notations. PWS |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Recording a macro | New Users to Excel | |||
| My excel macro recorder no longer shows up when recording macro | Excel Discussion (Misc queries) | |||
| My excel macro recorder no longer shows up when recording macro | Excel Discussion (Misc queries) | |||
| Add value when recording a macro | Charts and Charting in Excel | |||
| Macro recording box | Excel Programming | |||
![Paul W Smith[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
