Djblois
04-18-2008, 06:52 AM
lngIndOverHead = Range("B67").Value
Range("B67").FormulaR1C1 = "=R[-66]C*.01" + lngIndOverHead
It keeps crashing on the second line of code. I don't know why? I have tried a few different ways. I need to replace the value in a field with a formula that relates to itself and that is why I used the variable, so I do not get a circular reference.
Range("B67").FormulaR1C1 = "=R[-66]C*.01" + lngIndOverHead
It keeps crashing on the second line of code. I don't know why? I have tried a few different ways. I need to replace the value in a field with a formula that relates to itself and that is why I used the variable, so I do not get a circular reference.