Code not working properly

Hi and thanks for all your help thus far.

This code came largely from you guys and it seemed to pass every test that I could think of, however when put to the ultimate test (that being trying to run it with my actual information) if fails and puts things in the wrong order.

I can post a workbook if needed (it will take some work to pull the sensitive info out again) but I hoped that perhaps someone could tell me what might make the code fail only when I start adding real information.

Please Login or Register  to view this content.

Thanks,
Tom

Hi Tom,

It would help if there was a bit more clarity about

if fails and puts things in the wrong order.

Have you changed the workbook (VBA code excepted of course) since your previous sample was posted, if not the repost that as an assist

Cheers

Jmac

Fair enough. It is supposed to put data on separate pages based on number...anything 400000-401000 should go on all pages while 401000-402000 in certain pages (a group of red pages), 402000-403000 to yellow pages, 403000-404000 - green, and 404000-405000 to blue.

It seems to work well in tests but when I start filling in all the info it starts copying everything to every page.

Column A should never change. In fact it could be hidden. It consists on 5 cells; ALL, P1, P2, P3, P4. These are what cause the code to separate the numbers into their respective categories; All for all, P1 for Red, P2 for Yellow, P3 for Green, P4 for blue.

Lol...bleeding obvious...yeah. Well it was worth a shot. I mean, everything checks out in the test runs and I can see no difference in the actual run. There is nothing at all that SHOULD affect the code.

1. are you sure that cell A1002 does contain "P1" and so on for the other groups?

column a is as it should be.

2. it looks like you are not triggering the change of event code correctly with your data so that may be an avenue to try to debug

I am unsure what you mean. Going through te code step by step there is one point where, when you hover over the code and it shows what is happening, it should say Event Code=4 but instead it shows Event Code=0. I figure that might be the problem, but I cannot understand what would cause that to happen...

This is where I am talking about.

Please Login or Register  to view this content.

Even that, though, seems to change randomly...

Wow...I hate that you have gone to all the trouble trying to help me. I just realized that every time I have tried to test this I started at the top of every category...for example in P1 I started my data at number 401000, however when I started my actual data (because I was using data from a previous user) I started one row down.

Now, I confess that I do not understand why this makes it fail but evidently it does...learned something new. Thanks so much for your help, I am sorry to have bothered you.

Cheers
Tom

Lol, thanks for your patience.

It seems to be the only problem (though I do not understand it). It's working fine now.

Tom