Assigning name to current region
Hello
After selecting the current region, I would like to assign the name
Total_Statistic. The region can change and the name should be overwritten
each time I run the macro.
I am selecting the region as follows:
Set tbl = ActiveCell.CurrentRegion
tbl.Select
I can't find the right VBA command to assign a name, given that this isn't a
cell reference. Would really appreciate some help!
--
Thanks very much. KDJ
|