Paste values instead of formulas

[Kamalakar M]

Hi Team,

i am managed to write a macro to which performs certain steps and finally i am copying the data from one sheet to another sheet.

But i am facing problem while copying the data between two sheets as while copying it is copying formulas not the values available in each row.

example :

i have two sheets : "Source" and "Destination"

"Source" sheet contains data along with the formulas in it. now i am copying data from sheet "Source" to "Destination" , the values are not copying , it is copying with formulas hence the data is showing in the "Destination" sheet as "#REF"

Below is the sample line of code i am using to do this operation. Can you please help me to correct the code so that while copying it should copy the values available in the "Source" sheet.

Sheets("Source").Columns.Range("A2:A75000").Copy Sheets("Destination").Range("A2")

Regards,
Kamal M.

[rorya]

You can use:

Please Login or Register  to view this content.

[bhavsarankit]

Please check if your destination excel sheet has the same columns and rows available. Sometimes it contains only 65000 rows.
As this is the #REF error, the reference cell is not available in your destination sheet.

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.

[Kamalakar M]

Hey Rorya...

Thanks a lot for your quick help on this. This works fine.

thanks once again.

Regards,
Kamal M.