Help modify code to auto-fit multiple named ranges

Hi guys,

I need some help auto fitting text in some merged cells.

I got the following code, thanks to Debra Dalgleish (http://blog.contextures.com/archives...ll-row-height/), that works great for a single named range. But, the problem is that I have multiple named ranges I would like to auto fit on the same sheet.

Is there perhaps a way i can do this? perhaps a loop or something? from either one range name to the next, or loop from row to row?

My ranges are named DelayDetail; DelayDetail2; DelayDetail3 etc.

Please Login or Register  to view this content.

Thank you!