Posted to microsoft.public.excel.programming

rbmcclen[_2_] rbmcclen[_2_] is offline

external usenet poster

Posts: 1

Find and select all

How do I get this:
Cells.Find(What:="bilbobaggins", After:=ActiveCell
LookIn:=xlFormulas, _
LookAt:=xlWhole, SearchOrder:=xlByRows
SearchDirection:=xlNext, _
MatchCase:=False).Activate
To select all matching cells at the same time

--
rbmccle
-----------------------------------------------------------------------
rbmcclen's Profile: http://www.excelforum.com/member.php...fo&userid=3636
View this thread: http://www.excelforum.com/showthread.php?threadid=56159

Reply With Quote

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

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 & Select	Celeste[_2_]	Excel Discussion (Misc queries)	3	December 1st 09 05:52 PM
find & select	Aaron Hodson \(Coversure\)	Excel Worksheet Functions	2	August 21st 08 08:36 AM
Find and Select	Judd Jones[_2_]	Excel Programming	2	December 29th 04 06:09 PM
Find All.... Then Select All	Jason	Excel Programming	2	November 7th 04 07:52 PM
Find then select to the right	JUAN	Excel Programming	2	April 30th 04 09:49 PM

All times are GMT +1. The time now is 03:40 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us