vba code throws an error first time but runs perfectly the second time. HELP!!

Hi,

I have written a vba script that automate the generation of reports. The script works fine as a whole. But I found out that Once I make any changes in the excel file like deleting an empty row or inserting an empty row -- which is not related to my calculation), the vba throws an error that displays the dialog box with nothing printed on it(i have attached the image of it). But When I execute it once again for debugging, it works fine. I am not sure where did I make the mistake.

Thanks.

Would help if you post the code! Although it looks like it could be an excel bug rather than something in your code. There might be suggestions here that help you (although they seem 2007 specific - what version are you using?):
http://www.excelforum.com/excel-prog...ssage-box.html

Hi. thanks for the reply. I am using Excel 2010. here is the code.

Please Login or Register  to view this content.

I am not sure what is going wrong here.

Now I made some changes (like inserting, deleting the empty rows) and i executed the script and it works now.