Using Command Buttons to Prioritize a Range

[siamadu]

http://www.excelforum.com/excel-pro...-a-command-buttons-to-prioritize-a-range.html

Here is the link to my original post:

My question is that the macro works fine. I want to revise this macro so that MoveUp() and MoveDown() only moves the values in the cell. Not the formatting and/or the formulas.

Right now, it is moving the formatting and formulas and proceducing the wrong out.

Please see the attachment excel file.

Thanks in advance for you help.

 

[siamadu]

Please help!!