LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
find value and display cell next to it Jambruins Excel Discussion (Misc queries) 2 March 26th 08 04:56 PM
find certain text and display it natek1234 Excel Discussion (Misc queries) 9 September 27th 07 02:44 AM
Find max # and display name [email protected] Excel Discussion (Misc queries) 2 September 13th 07 09:17 PM
Help:Find and Display kenrose08[_4_] Excel Programming 5 August 13th 06 09:44 AM
Find display the result Simon Excel Programming 5 January 18th 04 07:00 PM


All times are GMT +1. The time now is 05:27 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"