Find tool and cursor
An arrow may be a bit of an ask but try right-clicking the worksheet tab,
view code and then paste this in and see what happens. You should get the
search cell highlighted. In fact the active cell will always be highlighted.
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Static LastCell As Range
Target.Interior.ColorIndex = 3
LastCell.Interior.ColorIndex = xlColorIndexNone
Set LastCell = Target
End Sub
Mike
Mike
"Joe" wrote:
When looking for something in the spreadsheet with Crl+F I wouuld like to get
a short of an arrow or pointer to help me to identify the cell. Do u know of
any trick?
Thanks,
jose
|