F1 = Formula = "=subtotal(9,m1:m3000)"

Posted by Bob on August 24, 2001 7:33 AM

I need this to work in VBA, so I can put the value of
F1 into a button. I have the rest of the code working fine
I just can not remember the Syntax to make this work.

I thought it was like this (But it wasn't)

F1 = Application.Formula = "=subtotal(9,m1:m3000)"

Thanks..BJ

Posted by Alfredo on August 24, 2001 7:42 AM

Try using the macro recorder to get the correct syntax.