Worksheetfunction
Thanks for the tip on the unnecessary "Application".
As for Intellisense, as a touch typist, I find it very distracting. It
certainly doesn't save me any time (I can type faster than the time it takes
to figure out what delimiter or cursor action will get VBE to select the
choice). However, it is useful in seeing a list of valid choices, except
there are too many exceptions to its lists.
--
Regards,
Fred
Please reply to newsgroup, not e-mail
"Vasant Nanavati" <vasantn *AT* aol *DOT* com wrote in message
...
1. "Application" will not give you function names in the Intellisense
dropdown, nor will it give you an argument list for the function you type
in
manually.
2. "WorksheetFunction" will do both.
2. It is not necessary to preface "WorksheetFunction" with "Application."
I hope I've saved you a few keystrokes!
--
Vasant
"Fred Smith" wrote in message
...
What's the difference between Application.WorksheetFunction.Vlookup and
Application.Vlookup?
As far as I can tell they both work. However, one difference I've found
is
that when the Vlookup fails, Application.WorksheetFunction.Vlookup
returns
nothing, but Application.Vlookup returns N/A.
Is there any need to use WorksheetFunction? It would save a lot of
typing
if
I didn't have to use it.
--
Regards,
Fred
Please reply to newsgroup, not e-mail
|