Tweaking of Macro Code to sort rows

[swoosh]

I have some code for a macro that is designed to SORT multiple ROWS not columns. I have tweaked it a bit so that Column A would NOT be included in the sort of every row becuase it was a header row. However, I need only columns B through F sorted. Not Column G........I have got it to ignore column A, but how do I get it to ignore colum A and G?

Here is the code:

Please Login or Register  to view this content.

[JapanDave]

Please put your code in tags.
Try this,

Please Login or Register  to view this content.

[swoosh]

japandave,

PERFECT!!!!......works like a charm. I am still trying to wrap my head around how it actually works. Thank You so much for replying with this

[swoosh]

Oh now I see, you ended it with a 5. Sheesh!!!!!! so easy but yet I was stumped!!! Thanks Again JapanDave