Trying to change this to incorporate my last row, which is using the variable lLastRowDeDuped.
I receive #REF error when using this. The lLastRowDeDuped works for the first use of it, but does not work in the second instance where the 752 is.
Any assistance would be great!
VBA Code:
Range("B29").FormulaR1C1 = "=COUNTIFS(R[-27]C[5]:R781C[5],RC[-1],R[-27]C[10]:R[752]C[10],""<>""&""LINES SET TO 0"")"
I receive #REF error when using this. The lLastRowDeDuped works for the first use of it, but does not work in the second instance where the 752 is.
VBA Code:
Range("B29").FormulaR1C1 = "=COUNTIFS(R[-27]C[5]:R" & lLastRowDeDuped & "C[5],RC[-1],R[-27]C[10]:R[" & lLastRowDeDuped & "]C[10],""<>""&""LINES SET TO 0"")"
Any assistance would be great!