Automation : copy row

When I set an Automation to copy a Row from one worksheet to another worksheet in a different workbook, it gives an error as the Automation copies the cell formulas of original worksheet. Can’t we have just automate copy row only the data.

Thanks for the suggestion @Dhammike_Wimalaratne. Our copy/move row automation does not work this way today but we’ll consider this for the future.