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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need Help with a VBA subroutine 0
VBA for Dependents shortcut menu 0
AppleScript - How do I select a text ? 1
Remove Identical words 0
Cell data entering slow! 0
Copy addition formula of non-consecutive horizontal cells 2
Word macro that can call cells out of Excel for a find and replace 0
Pasting a cell into bookmarked table from excel vba 1

Top