cell reference in macro
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
|