Posted to microsoft.public.excel.programming

pm[_2_]

external usenet poster

Posts: 44

VBA formula building

hello,

i try to write a function corresponding to index and match
functions used in excel spreadsheets..

i have sth like this:

Function FindID(c As Variant, x As Integer)

'c - file (ie. [file1.xls]
'x - arkusz (ie. 4

FindID = "=INDEX('" & c & x & "'!R8C3:R8C154,1,MATCH(RC3,'" & c & x & "'!R15C3:R15C154,0))"

End Function

is it possible to build forumula in such a way?

best

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
Loose formula/value (when building graphs)	PvZ	Excel Worksheet Functions	3	June 2nd 10 12:24 PM
Formula Building in Excel 2007	Mike H.	Excel Discussion (Misc queries)	2	June 24th 09 01:46 PM
When building formula in excel, it would be very useful to have t.	[email protected]	Excel Programming	1	October 20th 04 12:07 PM
When building formula in excel, it would be very useful to have t.	[email protected]	Excel Programming	0	October 20th 04 11:09 AM
Building a Named Range in a formula with VBA	John[_80_]	Excel Programming	1	July 7th 04 03:06 PM

All times are GMT +1. The time now is 08:41 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us