Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Recording
I use a macro that contains the following line.
Range("A1").CurrentRegion.Name = "PriceTable" This line was edited manually to insert the 'CurrentRegion' part. It originally had a named range like A1:F25. Can this line be recorded? How in both Excel 2003 and 2007? OldEd |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Recording
Unfortunately not, the macro recorder will hard code whatever range is
selected. Naming a range by using the current region (whatever it is) must be done by writing VBA code. --JP On Sep 24, 2:46*pm, "OldManEd" wrote: I use a macro that contains the following line. Range("A1").CurrentRegion.Name = "PriceTable" This line was edited manually to insert the 'CurrentRegion' part. It originally had a named range like A1:F25. Can this line be recorded? How in both Excel 2003 and 2007? OldEd |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Recording
Thanks. Expected that might be the case.
What does the macro recorder do with the following key/mouse strokes? Open ......... Save as xxxx.xls Control A Type 'PruceTable' in range name box (top left) Save Stop recorder. Will control-A select everything that the 'CurrentRegion' does and then give it a name? ed "JP" wrote in message ... Unfortunately not, the macro recorder will hard code whatever range is selected. Naming a range by using the current region (whatever it is) must be done by writing VBA code. --JP On Sep 24, 2:46 pm, "OldManEd" wrote: I use a macro that contains the following line. Range("A1").CurrentRegion.Name = "PriceTable" This line was edited manually to insert the 'CurrentRegion' part. It originally had a named range like A1:F25. Can this line be recorded? How in both Excel 2003 and 2007? OldEd |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Recording
"OldManEd" wrote in message ... Thanks. Expected that might be the case. What does the macro recorder do with the following key/mouse strokes? Open ......... Save as xxxx.xls Control A Type 'PruceTable' in range name box (top left) Save Stop recorder. Will control-A select everything that the 'CurrentRegion' does and then give it a name? ed "JP" wrote in message ... Unfortunately not, the macro recorder will hard code whatever range is selected. Naming a range by using the current region (whatever it is) must be done by writing VBA code. --JP On Sep 24, 2:46 pm, "OldManEd" wrote: I use a macro that contains the following line. Range("A1").CurrentRegion.Name = "PriceTable" This line was edited manually to insert the 'CurrentRegion' part. It originally had a named range like A1:F25. Can this line be recorded? How in both Excel 2003 and 2007? OldEd |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Recording
After you record that macro, hit the F5 key, select the PruceTable name and
click OK. That will highlight the range that bears that name. HTH Otto "OldManEd" wrote in message ... Thanks. Expected that might be the case. What does the macro recorder do with the following key/mouse strokes? Open ......... Save as xxxx.xls Control A Type 'PruceTable' in range name box (top left) Save Stop recorder. Will control-A select everything that the 'CurrentRegion' does and then give it a name? ed "JP" wrote in message ... Unfortunately not, the macro recorder will hard code whatever range is selected. Naming a range by using the current region (whatever it is) must be done by writing VBA code. --JP On Sep 24, 2:46 pm, "OldManEd" wrote: I use a macro that contains the following line. Range("A1").CurrentRegion.Name = "PriceTable" This line was edited manually to insert the 'CurrentRegion' part. It originally had a named range like A1:F25. Can this line be recorded? How in both Excel 2003 and 2007? OldEd |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Recording Macro | Excel Discussion (Misc queries) | |||
Macro recording | Excel Discussion (Misc queries) | |||
How do I make the Stop Recording bar pop up when recording macros | Excel Worksheet Functions | |||
Recording changes | Excel Discussion (Misc queries) | |||
recording | Excel Programming |