OUTLINE THE CELL YOU'RE SEARCHING FOR

[AintQuiteRite]

   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.

[#2]

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)

[#3]

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".

[#4]

Hi, please see attached for steps to take. Someone may have a better idea.