Using Excel functions in a module - To Application.WorksheetFunction or not

[mikeymay]

I am building a tool that will need distributing to a number of users and there is the TRIM function being used in a module.

Now I have run into issues before where a tool wasn't being distributed and was only used by one person and different users have required the use of either of the following prior to the function

• Application.WorksheetFunction
• Application
• WorksheetFunction

How do I establish which of these will be required or is there a catch all option?

 

[mikerickson]

Re: Using Excel functions in a module - To Application.WorjsheetFunction or not

So my short answer to the OP is always use Application.something, its easier to handle.

 

[mikeymay]

Re: Using Excel functions in a module - To Application.WorjsheetFunction or not

Now that makes sense......

I think is probably what is happening then.

I'll try to get hold of the raw data he is using and test with that.

 

[mikerickson]

Re: Using Excel functions in a module - To Application.WorjsheetFunction or not

I'll try to get hold of the raw data he is using and test with that.

It's very optimistic to assume that a user is going to continue doing what they currently are.
Its safest to bullet proof your code against everything that a user might do.

Users are like Shakespeare's monkeys, you never know what key they are going to press.