Can code run faster

**leem** · 08-16-2010, 11:42 AM

I want to Thank you in advance for your vast knowledge and advice which has helped me out beyond belief.
Programming is not me because I don't understand all of it but can understand the basic...sort of. I was in need of coding that changed certain cells color and I was very happy with the code that was provided by davegugg. I took his code and added another sheet (MILES) and changed the color. Everything seems to be working just runs for alittle longer than I expected. This spreadsheet will be on a network which can be slow to the field so I'm just checking to see if there is a way to speed up the code? If not then I will run with it as it is.

the DR, FH,CL, MT tabs will never be more 3,000 rows
The LOA and Miles tabs will never have more than 300 rows

Please Login or Register  to view this content.

"This is the section I added but I really only need it to look through the DR tab"

Please Login or Register  to view this content.

Thanks
Michelle

**royUK** · 08-16-2010, 11:46 AM

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

**leem** · 08-16-2010, 11:53 AM

Didn't know about code tags but now I do...thank you.

I want to Thank you in advance for your vast knowledge and advice which has helped me out beyond belief.
Programming is not me because I don't understand all of it but can understand the basic...sort of. I was in need of coding that changed certain cells color and I was very happy with the code that was provided by davegugg. I took his code and added another sheet (MILES) and changed the color. Everything seems to be working just runs for alittle longer than I expected. This spreadsheet will be on a network which can be slow to the field so I'm just checking to see if there is a way to speed up the code? If not then I will run with it as it is.

the DR, FH,CL, MT tabs will never be more 3,000 rows
The LOA and Miles tabs will never have more than 300 rows

Please Login or Register  to view this content.

"This is the section I added but I really only need it to look through the DR tab"

Please Login or Register  to view this content.

Thanks
Michelle

**shg** · 08-16-2010, 12:37 PM

Try this (completely untested):

Please Login or Register  to view this content.

**leem** · 08-16-2010, 02:52 PM

Thank you very much and yes it runs much faster. Awesome! I don't want to sound unappreciative but I was also trying to distinquish gray for those on LOA (this would bring attention to those on leave or restriction) and light orange for the MILES (this would bring attention to those that drove miles instead of working hours). Never would there be a conflict between LOA and MILES colors.

Thanks
Michelle