I find that the best solution is to name the ranges that you want to use in
your macros. Then use the range names instead of the cell references.

--

Vasant



"iamn94" wrote in message
...
I need to add some rows and / or columns to a spreadsheet. After I add
the
columns / rows, the macros that I built blow up. I have tried adding $
signs
to the cell references, ie: Range("D56") becomes Range ("$D$56), but this
does not seem to work. In excel the formulas scale to reflect any row/col
additions or deletions.

Any thoughts on what I should do to the macro language to ensure that the
macro changes and the layout of the sheet changes?

Thanks
--
sd