I took the general thought from this in your debugging link:
I figured that I would go back and make sure that I understood what was happening at each step, doing the simplest thing and then moving forward. So... I just changed the original file with the changes I wanted and then saved it to a different filename.
Now that I have that working and understand what it's really doing, I'll move on to trying to just get the groups to populate in new workbooks.
When I get that down (and understand it) I'll try to do the subgroups into different worksheets. I realized when reading that debug link was that one of my main problems was tht I didn't really understand the code I was working with.
No, you didn't suggest I do this, but you pointed to the debugging link, which gave me a better understanding of what I should be doing so that I can debug better.
Have I made a wrong choice?
Quote:Once your program compiles cleanly and the duck doesn’t raise any major objections, if there’s still a bug then see if you can break your code up into smaller methods, each of which does exactly one logical operation. A common error amongst all programmers, not just beginners, is to make methods that try to do multiple things and do them poorly. Smaller methods are easier to understand and therefore easier for both you and the duck to see the bugs.
I figured that I would go back and make sure that I understood what was happening at each step, doing the simplest thing and then moving forward. So... I just changed the original file with the changes I wanted and then saved it to a different filename.
Now that I have that working and understand what it's really doing, I'll move on to trying to just get the groups to populate in new workbooks.
When I get that down (and understand it) I'll try to do the subgroups into different worksheets. I realized when reading that debug link was that one of my main problems was tht I didn't really understand the code I was working with.
No, you didn't suggest I do this, but you pointed to the debugging link, which gave me a better understanding of what I should be doing so that I can debug better.
Have I made a wrong choice?