Assigning name to current region
Hi KDJ,
Try something like:
Public Sub Tester03a()
Dim tbl As Range
Set tbl = ActiveCell.CurrentRegion()
ActiveWorkbook.Names.Add _
Name:="Total_Statistic", _
RefersTo:=tbl
End Sub
---
Regards,
Norman
"KDJ" wrote in message
...
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
|