Thread: [Solved] Resizing the Name range
View Single Post
 
Old 05-27-2011, 03:05 AM
OTPM OTPM is offline Windows 7 32bit Office 2010 32bit
Expert
 
Join Date: Apr 2011
Location: West Midlands
Posts: 981
OTPM is on a distinguished road
Default

Quote:
Originally Posted by derohanes View Post
Thanks. That was what I was afraid of. By "re-specify" I assume you mean to use a new name for a new range.
Hi
You would have to delete the range and re-create it using a larger selection. You use the same name again.
I would suggest you use the whole column and keep it sorted for ease of finding the correct tool.
Hope this helps
Tony
Reply With Quote