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
Formula:
Please Login or Register to view this content.
NEW LAYOUT
Formula:Please Login or Register to view this content.
Hi,
1. Removefrom the code, otherwise you will not notice strange behavior
Please Login or Register to view this content.
2. ReplacewithPlease Login or Register to view this content.If you still have problems a sample workbook with test data would be helpfulPlease Login or Register to view this content.
Please use [CODE]-TAGS
When your problem is solved mark the thread SOLVED
If an answer has helped you please clickto give reputation
Read the FORUM RULES
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
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks