Thread: Activate Cell
View Single Post
  #2   Report Post  
Bernie Deitrick
 
Posts: n/a
Default

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?