Posted to microsoft.public.excel.programming

Steved[_3_] Steved[_3_] is offline

external usenet poster

Posts: 76

Make a Change to Code

Hello From Steved

Set FoundCell = Sh.Columns(1).Find( _
what:="2220")

At the moment the Above only finds a single Value.

Can I expand it to find 3 Value's in the same row please.
The "2220" Value is in Col A But Value "267"and "6.00"
is between Col B and Col AK in the same Row.

Set FoundCell = Sh.Columns(1).Find( _
what:="2220","267","6.00")

Thankyou.

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
How do I make a Bar code ???	Wadewild	Excel Discussion (Misc queries)	2	June 9th 08 09:08 PM
how do i change or make this macro??? pictures and code included	dispelthemyth	Charts and Charting in Excel	0	March 17th 06 01:02 AM
how do i make a date change automatically if i change one before .	dpl7579	Excel Discussion (Misc queries)	1	January 11th 05 09:21 PM
make macro change (delete) its own code	as_sass	Excel Programming	4	August 26th 04 07:15 PM
Change code to make worksheets instead of workbooks	mikeb1[_4_]	Excel Programming	3	December 15th 03 03:23 PM

All times are GMT +1. The time now is 10:09 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us