Marking cells in Excel

F

FTL

Hi
In Excel, I am trying to "mark" some cells in the row that is active.
I have written this code:

vRad = ActiveCell.Row
vRef = "Range" & "(""G" & vRad & """)" & ".Select"

....but what can I do to "execute"...?
....Waht I want is to have Range("G5").Select if the active row is
5....

FTL
 
M

Matt Lunn

Would you like to automatically go to/mark G5 if row 5 is selected? You could use the SelectionChange event of the worksheet to do this.

Matt
 
Top