Alert icon
We're changing our privacy policy. This stuff matters.  Learn more  Dismiss

Excel Highlight Active Cell

Loading...

Sign in or sign up now!
Alert icon
Upgrade to the latest Flash Player for improved playback performance. Upgrade now or more info.
4,515
Loading...
Alert icon
Sign in or sign up now!
Alert icon

Uploaded by on Nov 14, 2009

In this video, I discuss the technique required for highlighting the Active Cell. Here we will use a combination of tools:

1. Excel named range
2. Excel conditional formatting
3. Visual Basic for Applications (VBA)

Category:

Education

Tags:

License:

Standard YouTube License

  • likes, 0 dislikes

Link to this comment:

Share to:
see all

All Comments (9)

Sign In or Sign Up now to post a comment!
  • Thanks so much. It pecked my brain at first, but now I feel 1000 times smarter!

  • Thanks Robert

    could u help me what's wrong in below code

    Private Sub Workbook_SheetSelectionChange( _ ByVal Sh As Object, ByVal Target As Range) With ThisWorkbook.Names("ACTIVECELL­ADDRESS") .Name = "ACTIVECELLADDRESS" .RefersToR1C1 = "= Address (" & ActiveCell.Row & "," & ActiveCell.Column & ")"  End With

    it's not work

    thanks

  • Robert, thank you for the lesson, it was very clear and concise. Thank you for taking the time to share your knowledge..

  • Thank Very Much this is a great function...:)

  • Hi

    Thanks for this great video.

    can u tell me plaese, why its highlight only in cell "A1" in my workbook?

    Regards

    Rafi

  • How do you make it work in Excel 2010?

  • Doesn't work in 2010.

  • Robert, help!

    I am a daily currency trader, what I want do is find a excel formula that when I enter the date for that day of trading that it will keep a running total of the percentage +/- made with each trade I open and close for that day only to reset it self when I enter a new date.

    Currently I enter a date in a cell in column "J" of each row for each trade, I can have as many as 20 trades a day, my last column "W" records the percentage made +/-.

  • Robert thanks for your lesson its quite clear . But i have a problem with merge cell (two cell combine into 1 cell) when i use the filter and filter the typical name of client but the filter only show the single cell data but not the merge cell data. i,e client A - do the action 1 and 2 so i combine the action together and put the client name so that i can see this one person do the double action. But i wan to print out the combination of the actions but filter only show one cell action. How??

Loading...

Alert icon
0 / 00Unsaved Playlist Return to active list
    1. Your queue is empty. Add videos to your queue using this button:
      or sign in to load a different list.
    Loading...Loading...Saving...
    • Clear all videos from this list
    • Learn more