I have a column (A) in an Excel spreadsheet which I want to copy to another column (B).
Column A contains calculated values. I only want to copy the values from column A to column B (not the formulas).
Can anybody give me some VBA code which will do this?
I have named the range of column A as "end" and column B as "previous".
Many thanks in advance