Thread: Edit/Find
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Chip Pearson Chip Pearson is offline
external usenet poster
 
Posts: 7,247
Default Edit/Find

Tommi,

Try something like

Dim FoundCell As Range
Set FoundCell = Cells.Find(what:="whatever", LookIn:=xlValues, _
lookat:=xlWhole, MatchCase:=False)
If FoundCell Is Nothing Then
MsgBox "Not found"
Else
MsgBox "Found in cell: " & FoundCell.Address
End If


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Tommi" wrote in message
...
Hello!
How to use Excel's Edit/Find -command form VBA?
I recorded a macro using it, but the macro didn't record anything relating
to Edit/Find.

Thanks for your help!

BR,
Tommi