Hi All,

This is probably easy but.

Due to the possibility that the VAT rate may change from 17.5% to 15% i need
to change a lot of prices.

All the prices in my sheet are inclusive of VAT, I need to find the VAT
amount, then find the price without VAT and then find the price of adding the
new VAT amount on to it.

I know how to do this with simple formulas on the sheet but i need to create
some vba code so i can run it in various workbooks.

Currently i have this in the cells.

A1 - £49.00 - price
B1 - =A1*7/47 - to get the VAT amount
C1 - =A1-B1 - price without VAT
D1 - =C1+15%

I can do the loops and stuff to run it down the sheet i just need the code
to allow all these details to be automatically entered as it goes down the
rows.

If anyone has any ideas about how i could find this that would be appreciated.