Hi.

Here's what I am looking to achieve. I have a list of actions like
such:

Name action cost VAT

Alex hamburger 3.59 1.2
Alex potato chips 5.06 1.6
John hamburger 3.59 1.2
Alex payment -3.59 -1.2

I also have a cell that should display balance.
Now, what I want it to do is to display a calculational result over a
FILTERED range, where filter is set via standard GUI. I am assuming
formulas are of no use here (please correct me if I am wrong), so what
I need to know is how to most efficiently traverse a FILTERED range in
VBA.

Thank you for your advice.

Alex.