Copy the sum of two cells and paste into one cell

[drop05]

I have a question, is it possible to copy the values from 2 cells in one workbook and paste the sum of those two values in a single cell in another workbook? Using a VBA macro

Example, A1 and A2 in workbook1 worksheet 1. Copy the values of those two cells and get the sum of those two values, A1 =1, A2 =1, and have that value and paste it into cell A1 in workbook2?

 

[maabadi]

why you don't use this code

Sheets("sheet2").Range("A1").Value = Application.worksheetfunction.sum(Sheets("sheet1").Range("A1:A2").Value)