Moving a Row's range to the bottom of the spreadsheet's list

Hi,

This is my first post here. Yay!

I have been searching for a VBA macro that will take a row's range, in this case I am using A:H, and move all that data to the bottom of the spreadsheet. I have only been finding macros that move this data to another worksheet and this is NOT what I want/need. I need it all to be on the same worksheet as per my supervisors request.

Unfortunately I can't post a copy of my spreadsheet due to the sensitive information in it, but I can say that my first 3 Rows, are part of my header:

USER:

Nickname/Comment:

MAC Addresses:

# Users:

Close?

Expiration Date:

New Expiration Date:

Distribution Version:

Everything below is just data filled in.

What I was hoping for is when I place an "X" in the "Closed?" column, that it would automatically highlight the entire Row's Range A:H red and move that row to the bottom of the spreadsheets list.

I don't know if the reason I can not find this anywhere is because it is impossible or what. But any help would be greatly appreciated.

Thank you all for you time.

You are a genius! Thank you so much. it works. This is exactly what I was looking for.

If it is not to much trouble to ask, can you make is so that if/when "X" get's removed or cleared from the "closed?" column it just un-highlights that row that was previous highlight? It doesn't have to move the row back or anything just removes the red highlight.

Otherwise. This is great.

This is perfect. Thank you so much for your time. This makes managing the spreadsheet so much easier.

@ excelSet

Welcome to the forum.

Based on your last post it seems that you are satisfied with the solution(s) you've received but you haven't marked your thread as SOLVED. I'll do that for you now but please keep in mind for your future threads that Rule #9 requires you to do that yourself. If your problem has not been solved you can use Thread Tools (located above your first post) and choose "Mark this thread as unsolved".
Thanks.

Also, as a new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.

@Cutter
I thought I did change it to Solve, I guess I closed my browser faster then before the change was saved. Sorry for the trouble.

Thanks again to Chippy and excelforum for all your help.