Hi,
I am using the code below but not getting a true copy / paste value etc.
The worksheet called MILEAGE at cell C32 has the formula =DOLLAR(D31*0.45) & currently shows £1.80
When i press the button the £1.80 is copied to cell reference E58 on the SUMMARY sheet but there is a mark in the cells...