You can't assign a formula like that, formulaarray needs r1c1 style references.
To make it dynamic:![]()
Range("T3").formulaarray = "=MAX((r3c3:r10000C3=r[]c3)*(r3c21:r10000c21))"
![]()
Sub macro_1 dim LetterCycle, Dayslate LetterCycle = 3 Dayslate = 21 Range("T3").formulaarray = "=MAX((r3c" & LetterCycle & ":r10000C" & LetterCycle & "=r[]c" & LetterCycle & ")*(r3c" & Dayslate & ":r10000c" & Dayslate & "))"
Bookmarks