Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Edit/Find
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using Find under edit | Excel Discussion (Misc queries) | |||
The edit - find command | Excel Worksheet Functions | |||
Find and edit column entries | Excel Discussion (Misc queries) | |||
Edit + Find | Excel Discussion (Misc queries) | |||
Edit/Find/Options/Look In/Values | Excel Worksheet Functions |