Functions not working after Cells.Value update

[EeeK]

Anyone have any idea why?

[Leith Ross]

Hello EeeK,

My Magic Eight Ball shows "Reply Hazy" and the cats broke my crystal ball. We will have to do this the old fashion way with you posting your workbook or the code you are having problems with.

[EeeK]

Sorry, the code is as follows:

Please Login or Register  to view this content.

[Leith Ross]

Hello Eeek,

The code looks good . What is not doing?

Not sure why you took the long way on the rows and columns in this line...

Please Login or Register  to view this content.

When you have already defined these variables...

Please Login or Register  to view this content.

You could have used this...

Please Login or Register  to view this content.

[EeeK]

Hi Leith, thx for your fast reply.

Please Login or Register  to view this content.

The above lines are for debug purpose, I'll comment off once everything is complete.

This sub is a callback trigger by a XLL UDF function.

The first time the function is called which trigger this sub, it's work fine but the second time I call, it return 0 without entering the function and the sub even I've set the breakpoints in both the function and sub.

And the third time I call the function, it's stop at the breakpoints twice. And subsequently calls is accumulative.

Any idea why?

[Leith Ross]

Hello EeeK,

I have never created an XLL add-in. You can look here for more information on them and associated problems. Thanks to Romperstomper for link.