Copy and Paste a Range of Cells into the next blank row on another worksheet

[charlie_jd]

Hi there, I am trying to be able to copy a selected range which I have done below...

Sheet2.Range("A2", Range("H2").End(xlDown)).Select
Selection.copy

However, I want to now copy this to the next blank row on another worksheet within the workbook. Can anybody help me try do this please.
I did try to attempt it by doing ...

Sheet13.Range("A1").End(xlDown).Paste

But, it comes up with the message "Object doesn't support this property or method"

Also, is it possible when pasting that it pastes the values and not the formulas.

 

[charlie_jd]

Brilliant Cheers

 

[Fluff]

You're welcome & thanks for the feedback.