In thread http://www.vbaexpress.com/forum/showthread.php?t=2906 TheAntiGates made the commentI need an expansion of that comment. I thought when you named a range, you would be specifying limits on the range. How can the rectangle be expanded? What am I missing?Define a named range over that rectangle, and refer to that in the code, if there's a chance the dimensions will change.