Worksheetfunction.IFERROR(SUBTOTAL(9,()) not working

[Sonyafm]

Hello,

I have this code that works
Code:
TUnits=Application.Workheetfunction.Subtotal(9,Range(MCRStartDateRng,MCRToDateRng.Offset(lastCell -1,0))

But when I have blanks in that range the code errors

I thought adding to the above code "IFERROR", would resolve when but it doesn't work
Code:
TUnits= Application.Worksheetfunction.IFERROR(Subtota(9,(MCRStartDateRng,MCRToDateRng.Offset(LastCell -1,0))),0)

How can I resolve this error or issue?
Thank you!

 

[RoryA]

You still need to use Application.Workheetfunction.Subtotal and not just Subtotal.

 

[Sonyafm]

Not sure I understood your reply. I know I have to use Application.Worksheetfunction.Subtotal, but how about including IFERROR?

 

[RoryA]

If you know, why didn't you?

TUnits= Application.Worksheetfunction.IFERROR(Application.Worksheetfunction.Subtotal(9,(MCRStartDateRng,MCRToDateRng.Offset(LastCell -1,0))),0)

 

[Sonyafm]

WOW! No I didn't know that!
Wonderful, THANK YOU SO MUCH!

 

[RoryA]

Glad to help.