Copying RESULTS of a FORMULA to another worksheet

[Scott Howell]

USING AN EXCEL MACRO, HOW CAN I COPY THE RESULT OF A FORMULA TO ANOTHER WORKSHEET. I DO NOT NEED THE FORMULA COPIED. REPEAT DO NOT NEED THE FORMULA ITSELF COPIED OVER. ALSO REFER ME TO A MS KB ARTICLE FOR THE SOLUTION TO THIS..........

 

[John Green]

Worksheets("Sheet1").Range("A1").Value = Worksheets("Sheet2").Range("B2").Value

or, if you want the formatted result:

Worksheets("Sheet1").Range("A1").Value = Worksheets("Sheet2").Range("B2").Text


--

John Green - Excel MVP
Sydney
Australia

USING AN EXCEL MACRO, HOW CAN I COPY THE RESULT OF A FORMULA TO ANOTHER WORKSHEET. I DO NOT NEED THE FORMULA COPIED. REPEAT DO NOT

NEED THE FORMULA ITSELF COPIED OVER. ALSO REFER ME TO A MS KB ARTICLE FOR THE SOLUTION TO THIS..........

 

[Mo]

Why can't you 'Paste Special...' and select values.

-----Original Message-----
USING AN EXCEL MACRO, HOW CAN I COPY THE RESULT OF A

FORMULA TO ANOTHER WORKSHEET. I DO NOT NEED THE FORMULA
COPIED. REPEAT DO NOT NEED THE FORMULA ITSELF COPIED OVER.
ALSO REFER ME TO A MS KB ARTICLE FOR THE SOLUTION TO
THIS..........