MrExcel.com - Your One Stop for Excel Tips & Solutions

changing multiple ranges

Posted by Sarah on October 03, 2001 5:23 AM

I am sure this is a really easy question but .... I have a spreadsheet where the number of rows changes each month. I always end up changing each named range individually - Is there a way that I can change all the ranges at the same time to include all the rows?

Posted by Barrie Davidson on October 03, 2001 8:25 AM

Sarah, can you provide a little more information. Where does your information come from? How many named ranges are you re-defining? What is the criteria for each named range (i.e., is Range1 always columns A to C)? What are the names of your ranges?

Barrie

Barrie Davidson

Posted by Sarah on October 04, 2001 5:13 AM

It's alright - I think I have worked it out. Well not exactly, but a way round it anyway! Thanks.