Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
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? |
#3
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
inserting data from a row to a cell, when the row number is specified by a formula in a cell | New Users to Excel | |||
Addition to Turn cell red if today is greater or equal to date in cell | New Users to Excel | |||
How can I activate cell shading in a protected worksheet? | Excel Discussion (Misc queries) | |||
GET.CELL | Excel Worksheet Functions | |||
VLookup resulting in a blank cell... | Excel Worksheet Functions |