Need to copy calculated field.

[kujito]

I need to copy the calculated values in a column and paste them into a different workbook and/or sheet. Is there a way to copy the values but not the formulae, or similarly avoid the #REF! error? All I need are the values. How they came about is immaterial.
TIA

 

[pbaldy]

Instead of pasting, use Edit/Paste Special and choose values.

 

[eoan]

Following on from this, is there any way in vba to paste both the values and formats of a given range? I know

Selection.PasteSpecial Paste:=xlPasteValues

followed by

Selection.PasteSpecial Paste:=xlPasteFormats

would achieve the same result, but is it possible to do it all in one go?

Thanks in advance!

 

[pbaldy]

Not that I'm aware of, but I'm not strong in Excel VBA. You may want to start a new thread on it.

 

[chergh]

AFAIK you can't I have two lines the same as you when i need to do this.