Home

OUTLINE THE CELL YOU'RE SEARCHING FOR

AintQuiteRite
New Contributor

   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.

3 Replies
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)
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".
Hi, please see attached for steps to take. Someone may have a better idea.