After getting help from you guys on how to do the macros auto sorting, I have played around with it a couple of day to make sure I understood what to do to make it work for me. So far all was good. so yesterday I spent most of the day doing my entire program.
Only problem was when I finished it I got an error saying: Code for this procedure exceeds 64K when compiled.
Break this, and any other large procedures, into two or more smaller procedures. then it gave me the entire code thing, I think explaining what cell I started with and what cell I finished at, and a whole bunch of stuff in between that I have no idea what they mean. but I did copy it just in case I may need it.

My question is when using Macros record Now and you get a message like this -procedure exceeds 64K Break this and any other large procedures, into two or more smaller procedures. is there a way to insert something into the code thing it was showing me to break it into section that will allow it to run my program. can I like put part 1 and part 2 in the code thing without having to do the whole program over again. man I hope so.