View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
[email protected] zigstick@gmail.com is offline
external usenet poster
 
Posts: 2
Default Macro Copy Active Cell to Range Name, loop

Thanks, but actually trying to capture the entire range of say, Active
cell of b10 to B13 (B10:B13), then move to the name field and type only
the data copied from the initial active cell. This would create a
named range, with the name being whatever is in the first cell ... in
this case, b10.

Thanks!!