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

--
Regards,
Tom Ogilvy


<zigstick@gmail.com> wrote in message
news:1114458564.385955.83720@l41g2000cwc.googlegroups.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!!
>