benedict98
New Member
Hello Excel enthusiasts,
I would really appreciate some help on this one...
I am trying to convert:
.FormulaR1C1 = "=COUNTIFS('Sheet1'!C7,""X"",'Sheet1'!C2,RC1,'Sheet1'!C12,""*""&R1C&""*"")/R2C"
into a .Application.WorksheetFunction format to speed up my macro.
[RC1,'Sheet1'!C12,""*""&R1C&""*"")/R2C"] these all need to be dynamic, but the first condition doesn't.
Please help!
I would really appreciate some help on this one...
I am trying to convert:
.FormulaR1C1 = "=COUNTIFS('Sheet1'!C7,""X"",'Sheet1'!C2,RC1,'Sheet1'!C12,""*""&R1C&""*"")/R2C"
into a .Application.WorksheetFunction format to speed up my macro.
[RC1,'Sheet1'!C12,""*""&R1C&""*"")/R2C"] these all need to be dynamic, but the first condition doesn't.
Please help!