Macro hangs up in formatting loop

[jacob@thepenpoint]

I have a report that I am trying to automate and I have run into a snag in getting the formatting to work. I am trying to alternate row color to make it a bit easier to read but it seems to want to hang up in the loop. Here is the code I am running, I don't see what I am doing wrong, and would appreciate any suggestions.

Please Login or Register  to view this content.

Thanks!

[shg]

Why not do this with conditional formatting?

http://www.osceola.k12.wi.us/docs/Ha...Formatting.pdf

[jacob@thepenpoint]

I will give that a try. For some reason, conditional formatting doesn't seem to like me very well, which is odd cause I'm really a nice guy.

[Richard Buttrey]

...and of course if you're using Excel 2007 or later there is the 'Format As Table' standard functionality which offers many different ways of formatting a range with a pyjama stripe look. No need for a macro.

[jacob@thepenpoint]

Thanks guys! This will give me something to work through over the long weekend.

[Richard Buttrey]

Thanks guys! This will give me something to work through over the long weekend.

Yes, I had a similar comment from one of our erstwhile cousins in an email today and I was somewhat puzzled by the long weekend reference until I twigged.

So perhaps you’ll forgive me if there’s just a little bit of me that wishes we hadn’t lost our American colonies.

[shg]

If you hadn't, we wouldn't be celebrating ...

[jacob@thepenpoint]

Thanks guys! The conditional formatting worked like a champ! I am still having some hanging during formatting but the shading is almost instantaneous.