Macro to copy data and paste values into seperate sheet

Hi, I have a macro that copies some cells (which contain formulas) and pastes the values into a new line further down on the sheet. It works fine but I would like to have it paste the values into a separate sheet. I have tried various different code but can't get anything to work?

Hope someone can help?

Please Login or Register  to view this content.

Assuming that you want to copy from sheet1 in to sheet 2. You need to change sheet names to reflect your actual sheet.

If you want to copy in to next empty column, use this line

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Hi Thanks, worked perfectly. I used the code to paste to next empty column. Also removed the entire row insert as that inserted a new row into sheet 1, thanks heaps.

Gordon