Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Hi
I Downloaded Morefunc.xll Version 4.0 (03/11/2005) from http://xcell05.free.fr/index.html and installed. It does not seem to work in my worksheet, so I went to Tools, Morefunc, then clicked on 'Include Moerfunc in the Workbook' then popped up 'Update' I clicked ok, then I got an error message saying 'Run Time Error 57017' Event Handler is invalid. then it makes a worksheet called 'Morefunc Storage Sheet'. The bad thing is I deleted the old version off my harddrive. What I've used it for is in column B There is random numbers anything from 1 to 40 going down the column. In column A, I put =IF(B2,MIN(10,B2),0) which makes any number over 9 turns to 0 in column A. I was helped in this newsgroup some years ago on how to achieve this, and was told to use 'Morefunc' I also use this formula =MCONCAT(IF(Q2:Q$10546=Q2,MOD(O2:O$10546,10),"")) If the problem cannot be solved is there somewhere I can download the old Version. Hope I've been clear. Thanks in Advance Dave |