I am trying to flip the desired selection around. making the bottom of the column, all the way up to the top, along with all the items in the same row.

How do I go about it in vba, while also adding it default button in my paste special menu?
Thanks.