ActiveCell.Resize(3,1).name = ActiveCell.Value

--
Regards,
Tom Ogilvy


wrote in message
ups.com...
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!!