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

mikeymay

Well-known Member
Joined
Jan 17, 2006
Messages
1,529
Office Version
  1. 365
Platform
  1. Windows
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

MrExcel MVP
Joined
Jan 15, 2007
Messages
24,237
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.
 

Excel Facts

Move date out one month or year
Use =EDATE(A2,1) for one month later. Use EDATE(A2,12) for one year later.

mikeymay

Well-known Member
Joined
Jan 17, 2006
Messages
1,529
Office Version
  1. 365
Platform
  1. Windows
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

MrExcel MVP
Joined
Jan 15, 2007
Messages
24,237
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.
 

Forum statistics

Threads
1,171,053
Messages
5,873,480
Members
432,981
Latest member
DMcDaniel

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top