Edit/Find

  • Thread starter Thread starter Tommi
  • Start date Start date
T

Tommi

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
 
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 (e-mail address removed)
 
Back
Top