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