Logo 
Search:

MS Office Answers

 Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Gracie Hughes   on Mar 04 In MS Office Category.

Worksheet functions in VBA


  
Question Answered By: Hamdan Younis   on Mar 04

There might be a language problem here ...

A function like

> Function MyQuery(rng as Range, rngtoCheck as Range
> MyQuery =
> IF(ISNUMBER(VLOOKUP(J8;WebQuery;5;FALSE));VLOOKUP(J8;WebQuery;5;FALSE);0)
> End Function

is not rewriting the function, it is using (or calling, or encapsulating)
it.

"Rewriting" would involve writing your own version of VLookUp from scratch.

Share: 

 

This Question has 26 more answer(s). View Complete Question Thread

 
Didn't find what you were looking for? Find more on Worksheet functions in VBA Or get search suggestion and latest updates.


Tagged: