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