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? |
All times are GMT +1. The time now is 08:27 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com