Recording

[OldManEd]

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

 

[JP]

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

 

[OldManEd]

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


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

 

[Otto Moehrbach]

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


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

 

[Otto Moehrbach]

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