Error 92.For loop not initialized

[ImranBhatti]

Hi

In one of my Dictator Excel Applications. I am encountering the "Error 92, For loop not initialized" error.The Error does not let the workbook opened with any sheet. It just shows a blank instance of Excel (Snap attached).For some reasons I am unable to attach the workbook for some reasons. Although I am sharing the Workbook_open() Code as it shows the error on opening.May some suggestions/solutions be provided with out the book attached?
whats wrong with the code bellow:

Please Login or Register  to view this content.

[xlnitwit]

Hi

Have you trusted access to the VBA project in the trust centre?

[ImranBhatti]

Sir the "Trust Access to the VBA Project to object Model" is ticked.

[xlnitwit]

Perhaps the issue is related to the fact that your product activation of Excel seems to have failed on that computer.

[ImranBhatti]

The Microsoft Office Activation wizard does pop up for every instance of Excel but other files have no issue.

[xlnitwit]

Do the other files have the same code in?

[ImranBhatti]

I am confirming the code equality of the file with others.

[ImranBhatti]

Yes the code is same for all books.

[xlnitwit]

Are you sure the error is in that code? If so, on which line?

The code itself is, in my opinion, hard to follow due to the large number of redundant commented out lines, and also contains a fair amount of seemingly pointless code (e.g. enabling events from a Workbook_open event which wouldn't be running if events were not enabled). Furthermore, assuming that code is in an add-in, there does not appear to be an active workbook- something to which it refers frequently.

[ImranBhatti]

I have tested and now make the lines as red in the first post. The error message pops up as it is concatenated in the error handler(Red lines).
And the last line that executes before reaching to message box is also red above.

[xlnitwit]

I don't see how you could get to the red line, if the For loop (which precedes it) is in error. Is there any event code in the DataValues sheet?

[ImranBhatti]

Yes
The "DataValues" sheet has the following code

Please Login or Register  to view this content.

[xlnitwit]

I honestly cannot see anything in the code that is incorrect, so I'm afraid the onus is on you to do some debugging since you have the actual workbook in front of you.

[ImranBhatti]

Yes I understand that it is too difficult to help by looking a piece of code of a large application.I will try to debug it as prescribed and let you know the come outs.

Thanks a lot for trying so hard to help out.

Best Regards
Imran Bhatti

[xlnitwit]

If you can provide the workbook, I will try and help further but I realise that may not be an option.