Syntax Subtotal with variable

[Pierre]

Hello,
I would like to make my subtotal calculation depending on variable.

Right my formula is on the whole G Column:
Application.WorksheetFunction.Subtotal(9, Range("G:G"))

I add 2 variable (lmin and lmax) which will determine the first and last line to use

I tried this but doesn't work
Application.WorksheetFunction.Subtotal(9, Range(Cells(lmin, "G"), Cells(lmax, "G"))

Thanks in advance for helping

 

[Debaser]

You're missing a closing bracket but otherwise the code is correct.

 

[Pierre]

Indeed , I thought I did that but seems not

In the same area, I'd like to change the following formula:
Evaluate("=MATCH(SUBTOTAL(5,(K:K)),K:K,0)")

So that the range are Klmin:Klmax

 

[Debaser]

You need to concatenate them in:

Evaluate("=MATCH(SUBTOTAL(5,(K" & lmin & ":K" & lmax & ")),K" & lmin & ":K" & lmax & ",0)")

 

[Pierre]

That's seem to do the trick
Thanks a lot, it's always a bit difficult for me do manage variable in range