Dynamic MAx formula

[tariq2]

Hi, the code below is a hard-coded version of what I require.
Below I have columns C and U, however I nned to vary these with column headings,

so currently 'Letter Cycle' is Column C and 'Days Late' is Column U. But these may vary?
AN help on creating a dynamic code is much appreciated

Range("T3").FormulaArray = "=MAX(($C$3:$C$10000=$C3)*($U$3:$U$10000))"

[ragulduy]

You can't assign a formula like that, formulaarray needs r1c1 style references.

Range("T3").formulaarray = "=MAX((r3c3:r10000C3=r[]c3)*(r3c21:r10000c21))"

To make it dynamic:

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 & "))"

[tariq2]

Thank you - extremely helpful