Using a Command Buttons to Prioritize a Range

Does anyway to use a scroll bar to priortize a selected range?

I have included a simple example that I would like to rearrange with a scroll bar.

For example, I would want be able to select one row in the range and then place it either above the current position or any where in that range.

Any ideas?

Please see attachement

This uses two command buttons rather than the scroll bar.

Please Login or Register  to view this content.

I just took a quite look at your example and that is exact what I need. That should do the trick. I will try to incorporate with into my spreadsheet and let you know if I have any problems with transferring the code.

Thanks so much!!! You are a life saver!!!

I tried to modify the code the select a certain range of cells to move up and move down, but it keeps givening me an error message. The Range that I included in the code below, is the range I would like the select and than priortize with the two command buttons.

Please Login or Register  to view this content.

You're code worked for me.
What error are you getting?
Is the sheet protected?

You original code seems to be working fine. I have attached the actual spreadsheet that I wanted to incoporate the code into.

I seem to be having problems with my forumulas and your code.
In my spreadsheet, I have some conditional formatting that is needed to drive the spreadsheet. When you review my spreasheet, you will see how formulas in Column AN:BR and the conditional formatting works.

My problem is that when I use the Move up and Move Down code to prioritize my projects, it some how rearranges my formulas in Columns AN:BR. Therefore, not given me the correct condtional formatting.

Could it be that your code is moving the entire row, instead of the values in the row? That is just my guess.

Please advise.

Any thoughts?

I don't know why its not copying the formats.

No No!! Sorry, I think I did not explain myself clearly.

I do not want it to copy the formats. I want the conditional formating and formulas to remaining the same. I only want it to move the values up and down in a range.

I think this will do what you want.

Please Login or Register  to view this content.