Hi, and thanks in advance, I have recorded a macro, when I ran it, it came up with a "1004 Runtime Error". when I debugged it it showed the formula I had created contained the error, can anyone help here, I'm not really efficient with code, the formula is as follows;
in Cell M4 - =IFERROR(IF(N4>0,N4,IF(L4=45,'Build Sheet'!$J$7,IF(L4=60,'Build Sheet'!$J$8,IF(L4=90,'Build Sheet'!$J$9,IF(L4=120,'Build Sheet'!$J$10,IF(L4="V & Test 45",'Build Sheet'!$J$14,IF(L4="V & Test 60",'Build Sheet'!$J$15,IF(L4="Test",'Build Sheet'!$J$11,IF(L4="Test 45",'Build Sheet'!$J$12,IF(L4="Test 60",'Build Sheet'!$J$13,IF(L4="",""))))))))))),"")
Macro Recorded this;
Range("M4").Select
ActiveCell.FormulaR1C1 = _
"=IFERROR(IF(RC[1]>0,RC[1],IF(RC[-1]=45,Buildsheet!R7C10,IF(RC[-1]=60,Buildsheet!R8C10,IF(RC[-1]=90,Buildsheet!R9C10,IF(RC[-1]=120,Buildsheet!R10C10,IF(RC[-1]=""V & Test 45"",Buildsheet!R14C10,IF(RC[-1]=""V & Test 60"",Buildsheet!R15C10,IF(RC[-1]=""Test"",Buildsheet!R11C10,IF(RC[-1]=""Test 45"",Buildsheet!R12C10,IF(RC[-1]=""Test 60"",Buildsheet!R13C10,IF(RC[-1]=""""," & _
"))))))),"""")"
Cheers!
in Cell M4 - =IFERROR(IF(N4>0,N4,IF(L4=45,'Build Sheet'!$J$7,IF(L4=60,'Build Sheet'!$J$8,IF(L4=90,'Build Sheet'!$J$9,IF(L4=120,'Build Sheet'!$J$10,IF(L4="V & Test 45",'Build Sheet'!$J$14,IF(L4="V & Test 60",'Build Sheet'!$J$15,IF(L4="Test",'Build Sheet'!$J$11,IF(L4="Test 45",'Build Sheet'!$J$12,IF(L4="Test 60",'Build Sheet'!$J$13,IF(L4="",""))))))))))),"")
Macro Recorded this;
Range("M4").Select
ActiveCell.FormulaR1C1 = _
"=IFERROR(IF(RC[1]>0,RC[1],IF(RC[-1]=45,Buildsheet!R7C10,IF(RC[-1]=60,Buildsheet!R8C10,IF(RC[-1]=90,Buildsheet!R9C10,IF(RC[-1]=120,Buildsheet!R10C10,IF(RC[-1]=""V & Test 45"",Buildsheet!R14C10,IF(RC[-1]=""V & Test 60"",Buildsheet!R15C10,IF(RC[-1]=""Test"",Buildsheet!R11C10,IF(RC[-1]=""Test 45"",Buildsheet!R12C10,IF(RC[-1]=""Test 60"",Buildsheet!R13C10,IF(RC[-1]=""""," & _
"))))))),"""")"
Cheers!