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...

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!