View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_3_] Bob Phillips[_3_] is offline
external usenet poster
 
Posts: 2,420
Default Autoname a range

Assume the variable rng points at the table

rng.Name = rng.Cells(1,1,).value

--
__________________________________
HTH

Bob

"CLB" wrote in message
...
Thanks in advance.

Is it possible to automate the naming of a range, say of a table, as say
the
intersection of the row and column headers?