My loop macro is not working, returning a mismatch error??

[mnammari001]

I have written the below macro. The idea is to keep the macro running until the difference between 2 ranges (Dividend_payout and Dividend_payout_paste) become 0. The "dividend_payout_req_check" is the difference between the above 2 ranges. I have used this same type of macro before with and it seemed to work well. Currently the macro stops running and gives me a mismatch error no. 13.

if i ignore the error and keep activating the same macro, i eventually get the required result, but this requires several iterations and i keep getting the error even after the difference becomes "0". Any idea why this may be??

Thanks

Please Login or Register  to view this content.

[/I]

[patel45]

can you attach a sample file for resting ?

[mnammari001]

Thanks for responding. Its a rather large file (15Mb's plus) and is actually composed of multiple files. It also contains confidential infomration. Is there any other way i can shed more light on my problem for you?

Thanks

[bulina2k]

Hello,

I don't know if this works (in absence of your sample/file) but you could try to round up the value in the range, not the range so you might add ".value" :

Please Login or Register  to view this content.

[JOHN H. DAVIS]

Can't really tell what's happening without a sample. You may have text data in the range you are trying to calculate? Anyway my best guess. To avoid the error you could try this.

Please Login or Register  to view this content.