Go to InsertNameDefine... and add the name and the range it refers to.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"becca122121" wrote in message
...
I have an excel worksheet that I am trying to convert into my outlook
contacts but everytime I do it tells me I have to name ranges in excel
first.
and I dont know how to do that