Highlight Row and Column headers of active cell

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance


Hi folks.

What I'm going for is highlighting the Row and Column *headers* of the
active cell.
E.g. if the Active Cell is E5, I'd like the E and the 5 to be
highlighted.

Presumably the code will be linked to the SelectionChange event,
couldn't get anything to work though.
Any quick fixes wizards?

Regards

.

Relevant Pages

  • Re: Can barely see cell indicator
    ... > While moving around the spreadsheet I can barely see the nighlighted ... > outline around the active cell. ... Activecell highlighting is controlled by the System preferences. ...
    (microsoft.public.mac.office.excel)
  • RE: Row Column Cross Hair
    ... Private Sub App_SheetSelectionChange(ByVal Sh As Object, ... .Pattern = xlSolid ... Not sure when first introduced but this will do the highlighting you require ... to the active cell? ...
    (microsoft.public.excel.worksheet.functions)
  • Highest value in each column
    ... Obviously it is highlighting just the one highest value in column A. Not sure how to go about this. ... conditional formatting to each row individually but this would take far to ... Select all your data with A1 the active cell ...
    (microsoft.public.excel)
  • Row Column Cross Hair
    ... Is there a way to extend that highlighting into the sheet ... to the active cell? ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Generic generics help
    ... You're correct, I totally missed it, thanks for highlighting it. ... method that can manipulate either one of the headers and accept a parameter ... method in case you missed the change the first time. ...
    (comp.lang.java.programmer)