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

Copy and Paste Special in seperate operations. eg...

Selection.Copy
Sheets("Sheet2").Select
Range("A3").Select
Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone,
SkipBlanks:= _
False, Transpose:=False

Thanks Donna (and thanks Tom, although I used Donna's as she was there first!)

My colleagues all think I'm some kind of Excel genius now... I'm not gonna
tell them it's you guys who are the real geniuses!

Many thanks

Phil

" wrote:

Copy and Paste Special in seperate operations. eg...

Selection.Copy
Sheets("Sheet2").Select
Range("A3").Select
Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone,
SkipBlanks:= _
False, Transpose:=False

Defoes...you ought to use Toms......it's a better way of doing it.

Done it now using yours and it works... so not really worth changing it!

Phil

" wrote:

Defoes...you ought to use Toms......it's a better way of doing it.

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



--
Regards,
Tom Ogilvy

"Defoes Right Boot" wrote in
message ...
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