I have an estimating template which I recorded some macros for. The macros
change several unit rates automatically and re-calculates my bid price.

The problem I am concerned about is that if I add rows, my macro ends up one
row off. I tried naming the cells that change and adding the new names to
the macros, but that is not able to correct the offset caused by adding rows.


1) I would like to be able to safely add rows without messing up all my math

but

2)will settle for a work around that prevents someone from adding rows, if
that is possible.

Any suggestions? Thanks,

Andy

I'd be happy to help, but could you send me the spreadsheet? Post back here
when you have emailed it. mc19991999 @ hotmail

"AJB" wrote:

I have an estimating template which I recorded some macros for. The macros
change several unit rates automatically and re-calculates my bid price.

The problem I am concerned about is that if I add rows, my macro ends up one
row off. I tried naming the cells that change and adding the new names to
the macros, but that is not able to correct the offset caused by adding rows.


1) I would like to be able to safely add rows without messing up all my math

but

2)will settle for a work around that prevents someone from adding rows, if
that is possible.

Any suggestions? Thanks,

Andy

Unfortunately, the template is proprietary and dumbing it down would take
forever. This is how the macro currently is after I named the cells that
need to change between products.

Range("labor_rate_1").Select
ActiveCell.FormulaR1C1 = "=R[-1]C[5]-0.01"
Range("labor_rate_2").Select
ActiveCell.FormulaR1C1 = "0.8"

Hopefully that make my problem a little clearer?


"Mike" wrote:

I'd be happy to help, but could you send me the spreadsheet? Post back here
when you have emailed it. mc19991999 @ hotmail

"AJB" wrote:

I have an estimating template which I recorded some macros for. The macros
change several unit rates automatically and re-calculates my bid price.

The problem I am concerned about is that if I add rows, my macro ends up one
row off. I tried naming the cells that change and adding the new names to
the macros, but that is not able to correct the offset caused by adding rows.


1) I would like to be able to safely add rows without messing up all my math

but

2)will settle for a work around that prevents someone from adding rows, if
that is possible.

Any suggestions? Thanks,

Andy