SETV and GETV

[pilot]

Using a networked version of Excel 2002 keeps me from downloading and using the Morefunc addin. I tried to create my own UDF for SETV and GETV but I'm afraid I got nowhere. Is it possible to do that, and more importantly, is there anyone willing to undertake this?

 

[Ivan F Moala]

On 2002-09-13 06:15, pilot wrote:
Using a networked version of Excel 2002 keeps me from downloading and using the Morefunc addin. I tried to create my own UDF for SETV and GETV but I'm afraid I got nowhere. Is it possible to do that, and more importantly, is there anyone willing to undertake this?

What do these functions do ??
perhaps someone will create one if you explain what the function do and what paramtres they take etc.

 

[Aladin Akyurek]

That's very annoying... System folks/policies that prevent installing morefunc.xll.

Stephen Dunn has created a single function version in VBA which you need to insert as a module:

Public Function V(Optional vrnt As Variant) As Variant
'
' Stephen Dunn
' 2002-09-12
'
Static vrntV As Variant
If Not IsMissing(vrnt) Then vrntV = vrnt
V = vrntV
End Function

Usage example:

=IF(ISNA(v(VLOOKUP("q",F2:G5,2,0))),0,v())

Aladin

 

[Aladin Akyurek]

On 2002-09-13 06:23, Ivan F Moala wrote:

On 2002-09-13 06:15, pilot wrote:
Using a networked version of Excel 2002 keeps me from downloading and using the Morefunc addin. I tried to create my own UDF for SETV and GETV but I'm afraid I got nowhere. Is it possible to do that, and more importantly, is there anyone willing to undertake this?

What do these functions do ??
perhaps someone will create one if you explain what the function do and what paramtres they take etc.

Ivan,

Morefunc.xll is the best add-in available, written in C (or C++) by Longre, which offers a variety of functions that are as fast as built-in functions of Excel.

Just do a search here on morefunc to see the way what SETV, GETV, and other functions are used.

Aladin

 

[pilot]

Thanks Aladin (and Stephen), this looks so simple. Originally I wasn't worried about the double work required because of how my IF(VLOOKUP…) statements were constructed but as the workbook grew, well you know the rest.