View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
KDJ KDJ is offline
external usenet poster
 
Posts: 19
Default 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