Having sorted my previous problem, I now need to know how to copy just the
result of a formula to a new cell and not the actual formula.

I am using this line :

Worksheets("CURRENT").Range("B1").Copy _
Destination:=Worksheets("Balance Order Form").Cells(Rownumber, 1)

but that copies the formula in cell B1 of sheet "CURRENT" not the result of
the formula... so obviously if the details that are referred to in the
formula change then so does what has been copied, whereas once it's copied I
need the result to then be unchangeable.

Any ideas?

Thanks

Phil