For that Mike you may want to use a dynamic named range...

http://www.cpearson.com/excel/named.htm
--
HTH...

Jim Thomlinson


"Jim Cone" wrote:


You could use a named range.
Rows inserted into a named range expand the range...
Range("FlexRange").Interior.ColorIndex = 40
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)



"Mike M." <Mike
wrote in message
I have written a macro to change the cell format over several speciffic
ranges. Two if the ranges are meant to be flexible by added rows. The macro
as an absolute value default does not recognize the added rows and as a
result the format changes in the wrong area. Is there a work around here? A
way to have the macro flex when the rows are added?