Thread: [Solved] Resizing the Name range
View Single Post
 
Old 05-25-2011, 07:36 AM
derohanes derohanes is offline Windows Vista Office 2007
Advanced Beginner
 
Join Date: Oct 2008
Posts: 67
derohanes is on a distinguished road
Default Resizing the Name range

I'm using the list in conditional formatting for a dropdown list of tooling (Excel 2007). I identified a range and assigned it the name "Toolinglist" I now have tools that I need to add to that list and therefore need to establish a larger range.

How do I expand the range for "Toolinglist" without renaming it and changing all the references to it in my workbook?
Reply With Quote