Forum Discussion

AintQuiteRite's avatar
AintQuiteRite
Copper Contributor
Nov 20, 2018

OUTLINE THE CELL YOU'RE SEARCHING FOR

   When I'm in a database and need to find a certain cell, is there a way to make that cell easy to see when Excel finds it?  As it stands now, you have to roam the screen to find the "found" cell.

excel

3 Replies

  • Tanya Denton's avatar
    Tanya Denton
    Steel Contributor
    Nov 20, 2018
    This may work Right-click on your sheet's tab and View Code. Paste in the following: Private Sub Worksheet_SelectionChange(ByVal Target As Range) Cells.Borders(xlInsideVertical).LineStyle = xlNone Cells.Borders(xlInsideHorizontal).LineStyle = xlNone ActiveCell.BorderAround ColorIndex:=3, Weight:=xlThick End Sub (found on another site)
    • AintQuiteRite's avatar
      AintQuiteRite
      Copper Contributor
      Nov 26, 2018
      Tanya, thanks for replying to me. I'm not sure where this is to be pasted. A little further help would be greatly appreciated. I use the FIND tool in Excel nearly all day at work. It can drive you nuts finding where it "lit".
      • Tanya Denton's avatar
        Tanya Denton
        Steel Contributor
        Nov 26, 2018
        Hi, please see attached for steps to take. Someone may have a better idea.