About Us

Gord Dibben

Your first post was in worksheet.functions news group.

Message ID for my reply.

I will post my reply here in case you can't find the other one.

start post.............................................. .............

Only through VBA AFAIK

But it takes no longer to type into the find box than it does to type into a
cell.

What would you want to do with the results of your search?

This macro colors the found cells as gray.

Sub findthings()
whatval = ActiveSheet.Range("A1").Value
With Worksheets(1).UsedRange
Set c = .Find(whatval, LookIn:=xlValues, lookat:=xlPart)
If Not c Is Nothing Then
FirstAddress = c.Address
Do
c.Interior.Pattern = xlPatternGray50
Set c = .FindNext(c)
Loop While Not c Is Nothing And c.Address < FirstAddress
End If
End With
End Sub

end post.............................................. .....................

Gord

On Thu, 22 Oct 2009 14:04:04 -0700, adam
wrote:

I was able to locate the first post. Please point me in the direction.

Thanks!

"Gord Dibben" wrote:

You already have a couple of replies to your first post.

Suggest you go read them.

Gord Dibben MS Excel MVP

On Thu, 22 Oct 2009 12:51:01 -0700, adam
wrote:

How do I make a cell a search/find field. For example, all the data is in
column A. I want to make A1 a cell I can put data in and have it search the
rest of the spreadsheet for that data. Is there a way to do this? I know I
could just do ctrl+f but this needs to be done hundreds of times a day and
eliminating that would be helpful.
Thanks!

.

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Making a field value append a hyperlink	68jcode	Excel Discussion (Misc queries)	4	October 13th 09 09:25 AM
FIND / SEARCH text compare cell to string in 3rd cell	nastech	Excel Discussion (Misc queries)	0	October 29th 07 02:51 AM
Making one field equal 2 others	CMO	Excel Worksheet Functions	3	May 26th 06 11:47 AM
Search range of cells, find a value, output adjoining cell. How?	nyys	Excel Worksheet Functions	3	January 5th 06 01:48 PM
Find/replace search field defaults	Kristin	Excel Discussion (Misc queries)	0	November 18th 05 12:18 AM

Menu

About Us