Posted to microsoft.public.excel.programming

Edward Ulle Edward Ulle is offline

external usenet poster

Posts: 92

Using the Find method with formulas

I have a worksheet say Sheet1 that has values in column 1.

On Sheet 2 in column 1 I have formulas such as "=Sheet1!A1" etc.

I set the range to Worksheet("Sheet2").Range("A1:A1000").

The value 100 exist in column 1 of Sheet1.

I want to search the range for 100.

Set rRange = Worksheet("Sheet2").Range("A1:A1000")
rRange.Find(What:=100,LookIn:=xlValues,LookAt:=xlW hole)

Return Nothing.

Any suggestions?

*** Sent via Developersdex http://www.developersdex.com ***

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
Using variables to make a date and using find method to find that.	KyWilde	Excel Programming	2	April 21st 05 09:43 PM
Find Method	Garry Douglas	Excel Programming	0	December 31st 04 02:31 AM
with -.find end with method	Peter[_21_]	Excel Programming	1	December 26th 04 11:49 AM
Find method	benb	Excel Programming	0	September 22nd 04 10:17 PM
Using Find method	wade	Excel Programming	3	March 3rd 04 07:05 AM

All times are GMT +1. The time now is 06:24 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us