Prev Previous Post   Next Post Next
  #1   Report Post  
Dave 2005
 
Posts: n/a
Default Morefunc

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



 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 10:45 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"