Good evening,

This line of code works...

Range("C8:O8").Copy Range("C" & Rows.Count).End(xlUp).Offset(1, 0)
...but copies the formats etc as well.

How can I get it just to copy and paste the values please?

Thanks in advance.