Implementing same code into a new module

[boomboomblock]

Hi I was given a piece of code and told it would make my program run quicker but I don't really know how to implement my original code into the new piece. I have tried substituting pieces of code into it but I always get an error or the wrong outcome. If anyone could help me out with it I would be very grateful.

ORIGINAL CODE

Please Login or Register  to view this content.

NEW LAYOUT

Please Login or Register  to view this content.

[tehneXus]

Hi,

1. Remove

Please Login or Register  to view this content.

from the code, otherwise you will not notice strange behavior

2. Replace

Please Login or Register  to view this content.

with

Please Login or Register  to view this content.

If you still have problems a sample workbook with test data would be helpful

[boomboomblock]

The 'newSplitSheets' code is quite confusing to me anyway and when I put your code in it didn't work. The other code is working surprisingly fast now and I can't understand why, must be a temperamental piece of code! Thanks for the help anyway, always much appreciated

[tehneXus]

If you still have performance problems try my interpretation of splitSheets, if not please mark this thread solved.

Please Login or Register  to view this content.