For future questions you might ask on the newsgroups... you should always
mention the version of Excel that you are using (XL2003 and earlier are
usually assumed if the version is not mentioned).

--
Rick (MVP - Excel)


wrote in message
...
actually i am using ms office 2007 so the names[define] option can
viewed in the tab named 'formulas''names manager'