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.