paste same row into row of active cell

I have a worksheet with a row that has pars of data in it, c4:z4. I want to add a macro that selects that row, but pastes the values into whatever the active cell is, so I can copy into the following row to look for trends.

I'm thinking this has to be simple, but I'm missing something obvious. I've tried using the recorder to do what I want, and adjusting it to ActiveCell instead of the selection that I picked to paste into, but it doesn't seem to work.

Thanks in advance for any help. Attached is what I've tried... Thinking I've butchered it somehow, maybe multiple ways...

Sub selectcurrentsales()'
' selectcurrentsales Macro
'




'
    Range("C4:Z4").Select
    Selection.Copy
    ActiveCell.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
        :=False, Transpose:=False
    




End Sub

Re: paste same row into row of active cell

Thank you very much Smallman... works like a charm!!