Error 92: For loop not initialized...how to fix?

Code:

Please Login or Register  to view this content.

Hi, I'm new to VBA and am having trouble running this macro. For some reason, whenever i try to run it i get:
error 92: "For loop not intialized", at the point where i put the coding in for the Account Errors msg box. Any idea how to fix this error? It seems to work on other worksheets, just not my particular one.

Thanks

Hi

It is being caused when there are no errors to action. Try something like

Please Login or Register  to view this content.

HTH

rylo

Appreciate that. It started working to an extent. However it now only list the differences on the Expenses worksheet, not both the worksheets. Another issue is that it lists all data missing to the right of one point, even if the data is there. Ie. if i clear one cell and then run the macro, it says that all the information to the right of that cleared cell is missing, even though it isnt.

I have uploaded my .xlsm file for a better understanding. I dont really know where to go from here. Thanks

Hi

All the expenses from both sheets seem to be in the comparison area.

Can you set up something that has deliberate errors, and give the expected output you want to receive.

rylo

Hi

Try this. It does away with the conversion of the ranges to arrays, and works with the ranges directly.

Please Login or Register  to view this content.

rylo