Macro canīt be fired from another worksheet

Hello,

I've got the following macro in my workbook, and it works correct if started from the macro dialog box.
Iīve assigned the macro to a button on another worksheet, but it fails to fire the macro.

Am I right in assuming the macro needs editing (worksheet defining) in order to be fired from another worksheet?
I haven't found any reference to this problem on the net.

Please Login or Register  to view this content.

Vincent

There are a couple things you could do to improve this.
1. Declare all your variables. For instance, iCol is not declared as anything so if you want it to be of a Long variable you should declare it as such. Hence, your Dim line should look something like:

Please Login or Register  to view this content.

2. Declare the worksheet like:

Please Login or Register  to view this content.

Your procedure could look something like:

Please Login or Register  to view this content.

Let me know how it goes.