VBA Subtotal 109 formula

[Hurricanefly]

Hi all, I have this code. The

Please Login or Register  to view this content.

does not work but does if just

Please Login or Register  to view this content.

Also the formula is not working, Any ideas on this, it has to be

Please Login or Register  to view this content.

as it has filtered rows in it> All advice appreciated.

Please Login or Register  to view this content.

[JOHN H. DAVIS]

I think you need to use offset instead:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[Hurricanefly]

Hi that does not work for me!

[JOHN H. DAVIS]

It worked when it tested it? How does it not work?