Posted to microsoft.public.excel.programming

external usenet poster

Posts: 18

Find method

I want to search an entire sheet for a cell containing a value then return
the column number for that cell. I have tried variations of
n=Activesheet.Find ([value], LookIn: xlValues, LookAt: xlWhole).Column, but
any adaption I try gets a compile error. Any help?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to 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 Method	LiSa	Excel Programming	4	August 17th 04 04:10 PM
Using Find method	wade	Excel Programming	3	March 3rd 04 07:05 AM
Find method example	Shinichi	Excel Programming	3	August 22nd 03 10:39 PM
The find method	Stuart[_6_]	Excel Programming	0	August 5th 03 03:14 PM
Help with the Find method	Mike NG	Excel Programming	3	August 4th 03 07:15 PM

All times are GMT +1. The time now is 07:39 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us