I want to convert the below count & if function into a user defined function. However, its outcome is false. What's wrong with it? Can someone helps?? Thanks in advance!
Please Login or Register to view this content.
I want to convert the below count & if function into a user defined function. However, its outcome is false. What's wrong with it? Can someone helps?? Thanks in advance!
Please Login or Register to view this content.
that function only tests if the current selection contains the formula specified in the code. you need to use evaluate if you want to actually calculate that formula but I am not sure what the benefit of the udf is-the formula in the cell would be more efficient
Josie
if at first you don't succeed try doing it the way your wife told you to
Thanks Joseph! The reason is I want to hide my calculation. I have to let the user to know the raw data but cannot let them know to calculate it!
I have changed my code but the outcome is still "FALSE". Are there any problems?
Please Login or Register to view this content.
yes-the code is wrong and the formula makes no sense. what is the formula supposed to do?
The code is obtained from Macro recording but it doesn't work in module.
I want to use a User defined function to replace the formula in the spreadsheet "Master Table" of the attached file.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks