Change recorded macro to remove all the selects... trying to learn how.

Hi,

I'm trying to learn how to rewrite the code from a bunch of recorded macros so it doesn't have all the selects... since I've been reading this is bad. But I haven't been able to get it right yet... so thought I'd ask for some help. Hopefully someone can show me the equivalent to these... and then I'd be able to figure out the rest from there.

Please Login or Register  to view this content.

How about

Please Login or Register  to view this content.

Thank you for responding Fluff13... I should have said each one of those 5 codes is a separate macro... so they aren't run/grouped together. But using your code... is this pretty close for each one individually?

Please Login or Register  to view this content.

The 1st two should as I wrote them & the other three should be

Please Login or Register  to view this content.