Hi I have below working 2 different formulas, which run in a macro. I need a condition which one of them have to run.
If C12 is 03 or 3( don't know if it means anything about the zero) then
Range("C31").Select
ActiveCell.FormulaR1C1 = _
"=(R[-18]C[-1])&"" ""&TEXT(MID(R[-8]C[-1],11,5),""00000000"")&"" ""&TEXT(RIGHT(R[-8]C[-1],12),""000000000000"")&"" ""&""..""&RIGHT(R[-14]C[-1],6)&"" ""&"".....""&"" ""&RIGHT(R[-12]C[-1],1)"
Range("C32").Select
If not any of either 03 or 3 then run this one below
Range("C31").Select
ActiveCell.FormulaR1C1 = _
"=TEXT(MID(R[-8]C[-1],6,5),""00000"")&"" ""&TEXT(MID(R[-8]C[-1],11,5),""00000000"")&"" ""&TEXT(RIGHT(R[-8]C[-1],12),""000000000000"")&"" ""&""..""&RIGHT(R[-14]C[-1],6)&"" ""&"".....""&"" ""&RIGHT(R[-12]C[-1],1)"
Range("C32").Select
The codes are working its more the condition for which of them to run I cant find out off.
Please have a look thanks
Sincerely
Abjac
Bookmarks