Hi there,

Column I has formulas (=G1+H1) which need to become values. What I was thinking was to simply copy the column and use pastespecial to paste it again.

Code:
Columns("I").Copy
Columns("I").PasteSpecial Paste:=xlPasteValues
Nothing seems to happen.
What am, I doing wrong here? Thanks in advance.