set rCell=Cells(Activecell.row,"B")

will set rCell to same row as active cell, column B

HTH
--
AP

"Kurt Barr" a écrit dans le message de
news: ...
I'm trying to put together a macro that will take a value from one cell in
a
row, and then move it to another cell in the same row. The originating
cell
is going to vary, but the receiving cell is going to be in a constant
column
in the same row. I know about using offset to move over a specified number
of
cells, but I'm not certain as to how many cells I'm going to want to move
over to get to the same column in each row that I work with. Is there a
way
to use offset to move into a constant column?