Row_Calculation
I have a for a formula in a macro:
ActiveCell.FormulaR1C1 = _
"=MID(R[-11]C,FIND("","",R[-11]C,1)+2,10) & "" "" &
MID(R[-11]C,FIND(""D_"",R[-11]C,1)+2,FIND("","",R[-11]C,1)-FIND(""D_"",R[-11]C,1)-2)"
I need to replace the "-11" with a variable name that I calculate prior to
this.
Can I do this? If so, I need your help.
I still trying to understand macros.
thanks for looking.
El Bee.
|