Activate Cell

How do you write a macro to activate Cell(r,3) when the current active cell
is any other cell within the same row? How do you set the value of r to that
of the current active row?

Brett,

Cells(Activecell.Row,3).Activate

or

Cells(Activecell.Row,3).Select

HTH,
Bernie
MS Excel MVP

"Brett" > wrote in message
...
> How do you write a macro to activate Cell(r,3) when the current active
cell
> is any other cell within the same row? How do you set the value of r to
that
> of the current active row?

r = ActiveCell.Row

--
George Nicholson

Remove 'Junk' from return address.


"Brett" > wrote in message
...
> How do you write a macro to activate Cell(r,3) when the current active
> cell
> is any other cell within the same row? How do you set the value of r to
> that
> of the current active row?