View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Richard Hocking Richard Hocking is offline
external usenet poster
 
Posts: 12
Default Find and display

Hi all,

I'm currently using the code below to find specific data in a column in a
sheet. However, although it finds correctly, the whole column remains
highlighted which can make it difficult to see the cell found. Is there some
extra code I could add to highlight temporarily the cell found?

Columns(1).Select
Application.Dialogs(xlDialogFormulaFind).Show

Any suggestions much appreciated,

Richard.