A macro that copy and pastes to line below but pastes in a Values and numbers format

This is what I have so far but needs to paste special in the values and numbers format.


Range("3:7").Copy Range("A" & Rows.Count).End(xlUp).Offset(1)

Hello there try:

Please Login or Register  to view this content.

This is not working correctly. The formulas still show up and I get a Run-time error '1004' Method 'Range' of object'_Global' failed?