Excel does not recognize worksheetfunction.subtotal

[BrianPagan]

Hello!

I have many subtotals in one column and one of them in the middle is a vba formula worksheetfunction.subtotal, but excel does not know that and behaves as if it were just a number there and sums up everything. How could I make excel recognize vba subtotal?

If that is not possible, then I would like to give excel subtotal formula a range that I have defined in vba. How could I do that?

thanks!

 

[RoryA]

Glad to help.