Build in Cushion between Modules being Called

[reberryjr]

I'm having an issue where data is getting "jumbled" on a worksheet. There are only 2 modules that update this particular worksheet and I cannot replicate the issue when I step through each module, nor when I run them manually. My thought is that the "parent" module that is calling these 2 modules is "overloaded". It currently calls 38 modules in total, with 34 of those importing data from other excel files. I have this snippet after every module that is called. Do I need to increase the increment, or is there another/better way to build in a cushion (DoEvents perhaps)?

    Application.Wait (Now + TimeValue("00:00:01"))

 

[reberryjr]

Again, without the code it's only guesswork.
But if you are sorting and filtering the data itself and you are importing data in the sam place - I would say this is a bad decision.
At least IMHO.

I have to import the data to get it into the master workbook. I then have to sort certain data elements so that they are in the order my customer wants them in. I have to filter the data so that I can isolate certain values to perform various actions on or with those values.

 

[bobsan42]

Sorting can be tricky and can be a solid base for "jumbling".
Are you storing data in a table object or simply a range on the sheet?

 

[reberryjr]

Sorting can be tricky and can be a solid base for "jumbling".
Are you storing data in a table object or simply a range on the sheet?

This particular data is in a worksheet. My customers came up with more requirements that tripled the data being leveraged. Optimization will come after this gets rolled out due to timeline constraints. However, it appears that the issue was a filter not being cleared before running more code. So far, fixing that appears to have fixed the issue. Hopefully my continued testing won't prove that hope incorrect.