View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Frank Kabel Frank Kabel is offline
external usenet poster
 
Posts: 3,885
Default User Defined Functions

Hi
VLOOKUP can't work across sheets (also except MS noone will know the
code). Have a look at the morefunc.xll addin (the THREED function):
http://longre.free.fr/english

--
Regards
Frank Kabel
Frankfurt, Germany

"Roy Kirkland" schrieb im Newsbeitrag
...
I am writing an Excel application with considerable VBA in the back

end - I
have been attempting to use data stored on one sheet to supply

variables for
a calculation on another sheet, but have not been able to get Vlookup

to
work across sheets. Is there a workaround for this, or does anyone

know the
code behind the function, and if so, is it possible to write this

code as a
user defined function?

Roy