Copying

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Worksheets("Balance Order Form").Cells(Rownumber, 1).Value = _
Worksheets("CURRENT").Range("B1"),Value
 
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
 
Back
Top