relative reference

[Duce]

1) I use a macro to copy a range of cells (k9:n9) on the
active worksheet.
2) I select the leftmost cell to which I want paste the 4
values (values only). It always starts in the same
column, but the row is always different. I can paste
without incident.

What I would like to do is make a macro that pastes to
that manually selected cell and then simply moves over 5
cells to the right. When I do this the code is
always 'Range ("E95")' or some such so regardless of the
row I am on... the macro always ends on E95.

What do I code so as to get a relative reference? Is it
an r1c1 function?

Thanks,
Duce

 

[steve]

Duce,

Maybe
Activecell.Offset(0,5) to designate 5 cells to the right.