IssacJones
asked on
copying one column to another in vba excel
Hi
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
Issac
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
Issac
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Excellent
Worksheets("Sheet1").Range