Hi, I was wondering what the vba would be to highlight the cell in column A for the active row.
For Instance, if I were on cell D88 I would want cell A88 to be highlighted. Pretty sure would be a worksheet selection change event but not sure of the exact code.
May be something like that
Please Login or Register to view this content.
< ----- Please click the little star * next to add reputation if my post helps you
Visit Forum : From Here
You would need to decolorize the cells not in the active row first. So a little addition.
Please Login or Register to view this content.
Cheers!
Tsjallie
--------
If your problem is solved, pls mark the thread SOLVED (see Thread Tools in the menu above). Thank you!
If you think design is an expensive waste of time, try doing without ...
hmm, so that works but I need the highlighting to be removed if the row is no longer selected
beat me to it! Thanks guys!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks