Hi,
I am trying to use a R1C1 Sumproduct formula with a variable sheet, but I got stuck in this problem. I try to use the string "str" as the variable, yet Excel responds with run-time error 1004.
Any hints,please?
Here the code:
Thank you very much!For Each sh In Sheets str = sh.Name Sheets("Übersicht").Range("C" & 14 + i).Select ActiveCell.FormulaR1C1 = _ "=SUMPRODUCT((R14C='& str & '!R2C7:R71C7)*('& str & '!R1C10:R1C13=Übersicht!R[-3]C)*' & str & '!R2C10:R71C13))" Next sh
Bookmarks