adding rows to spreadsheet after macro is written

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

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" <[email protected]> wrote in message
news:[email protected]...
> 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

best to use a defined range name that will auto adjust
insert>name>define>name it mysumrange
in the refers to box
=offset($a$2,0,0,counta($a:$a,1)
look n help for offset. adjust to your needs

--
Don Guillett
SalesAid Software
[email protected]
"iamn94" <[email protected]> wrote in message
news:[email protected]...
> 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