Link to home
Start Free TrialLog in
Avatar of IssacJones
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
ASKER CERTIFIED SOLUTION
Avatar of KyleSW
KyleSW

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Range("End").Copy
Worksheets("Sheet1").Range("Previous").PasteSpecial xlPasteValues
Avatar of IssacJones
IssacJones

ASKER

Excellent