Offset from a variable column to a fixed column

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?

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

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

HTH
--
AP

"Kurt Barr" <[email protected]> a écrit dans le message de
news: [email protected]...
> 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?

Perfect!! That was just what I needed. Thanks!!

"Ardus Petus" wrote:

> set rCell=Cells(Activecell.row,"B")
>
> will set rCell to same row as active cell, column B
>
> HTH
> --
> AP
>
> "Kurt Barr" <[email protected]> a écrit dans le message de
> news: [email protected]...
> > 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?
>
>
>