Thread: Activate Cell
View Single Post
  #3   Report Post  
George Nicholson
 
Posts: n/a
Default

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?