Stop macro at the end of data / make macro faster

I have 5 macro's that I use everyday, multiple times a day. Thanks to this site, I am now able to run one macro to run all of them. Before, I ran each macro separately.

There were 2-3 other people involved in making these macros. I have managed them and keep adding "rules" to them.

Can you all take a look at the macros and help me with ideas on making the macros run faster? Also, I use 2007, but get 2003 sheets. I may get files with 100 rows and the next file will have 300,000 rows. The problem is the macro runs to the last row....65,536. It does not stop at last row with data. There is a code someone added to column B that could be deleted if I can get the the macro to stop at the end of the data.

Macro E are F and basically the same, but F is customer specific.

Thanks in advance for any help.

PS - I only put the codes in the attached worksheet to show you all what the functions are and the order they run in. Below this post, I have attached a typical worksheet that I work with.

How are you getting to the end of the line?
This is what I just did now:

Please Login or Register  to view this content.

Why have you posted a workbook with the code typed into a sheet/

If that's the code you are using then it would rumn more efficiently if you didn't select the ranges, etc

Selecting ranges, cells etc like you seem to do will slow code down considerable. A simple example

Please Login or Register  to view this content.

Application.ScreenUpdating will stop the screen refreshing as the code selects & speed up somewhat, but not actually selecting ranges will speed the code up dramatically up

It's much easier for us to see the code & edit it in the VB Editor

Ok, I think I'm starting to understand this a little better.

Here are the codes in order...I put them in separate posts and have shortened them to save space.

First:

Please Login or Register  to view this content.

I attached a worksheet that I work with on Page 1 of this thread. I have 9 Modules, but I use the first 5 several times a day. Macro A really isn't slow enough for me to worry about. It's Macro's B-E that are slow.

Since the macro was written by two other people, they use the "Selection". If "Range" will be faster, how do I edit the code? Also, will that stop at the last row of data. I am currently working on a spreadsheet that has 58,906 rows, but the macro worked down to row 1,048,576. I know that takes extra time, but I'm not sure what to change the code to.

I also added approx. 50 "rules" to A Macro this morning. So to write out the code above snb wrote, I think that would take me forever to change.

I really appreciate the help!!

Shane