Different Results from the Same Macro

Hello:

At the end of this posting, I have VBA code for a macro that I created. This macro was created in Excel 2007 macro. What's puzzling me is that this macro gives different results everytime that it is used. It is run against the same set of data, so I do not understand why it is producing different data in the spreadsheet.

The attached macro code "runs against data" in a spreadsheet in order to generate another spreadsheet.

Different results are given every time the macro runs. That's not good. The results need to be consistent. Is there anything in the attached code that can be modified to allow for consistency?

In terms of what is being seen different each time the macro runs, I am seeing different numbers of rows, different records in the columns, .....just no consistency.

Thanks!

Please Login or Register  to view this content.

disregard.....I figured it out.....it's an issue with the dataset inside of the accounting system.

I apologize, for the bother.