Hey guys,
I need some help with a sheet i am trying to create.
The idea is to have a list of cells B3,B4.B5.B6 for example and the user is able to drag B5 to the top of the list and the sheet automatically move B3 to B4, B4 to B5 etc. Just like the way you would if you selected B5 and held the shift key while showing the move pointer and dragged the cell up.
Is there a code or option i can use to ensure this is defaulted to manipulate excel to think that the user has held the shift key down?
In addition: is there then a way to force the move pointer onto the cell without having to find the bottom boarder?
I need some help with a sheet i am trying to create.
The idea is to have a list of cells B3,B4.B5.B6 for example and the user is able to drag B5 to the top of the list and the sheet automatically move B3 to B4, B4 to B5 etc. Just like the way you would if you selected B5 and held the shift key while showing the move pointer and dragged the cell up.
Is there a code or option i can use to ensure this is defaulted to manipulate excel to think that the user has held the shift key down?
In addition: is there then a way to force the move pointer onto the cell without having to find the bottom boarder?