value in the 1st col of a range

Posted to microsoft.public.excel.programming

banavas[_10_] banavas[_10_] is offline

external usenet poster

Posts: 1

value in the 1st col of a range

Dear Friends,

How can I check whether a value A exists in a range and specially i
the first column of the range?

I cannot figure out how does the rangeL.find() works.

msgbox(rangeL.Find(A)) breaks my code.

At last how can I pass a reference in a function?

ex.

VlookUp(ref, Range, 5, 0)

ref - the reference name of a value.

Thanks,

--
Message posted from http://www.ExcelForum.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
How do I enter formula sum(range+range)*0.15 sumif(range=3)	tkw	Excel Discussion (Misc queries)	2	October 1st 09 09:17 PM
Excel Addin:Setting the range to the Excel.Range object range prop	Rp007	Excel Worksheet Functions	5	November 24th 06 04:30 PM
Selecting range in list of range names depending on a cell informa	Courreges	Excel Discussion (Misc queries)	2	June 19th 06 10:59 AM
Range.Find returns cell outside of range when range set to single cell	Frank Jones	Excel Programming	12	June 10th 04 04:22 AM
how to? set my range= my UDF argument (range vs. value in range) [advanced?]	Keith R[_3_]	Excel Programming	2	August 11th 03 05:55 PM

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

Menu

About Us