What can I change ...![]()
Please Login or Register to view this content.
I want the macro above to run on what ever tab I have selected then I would press ctrl + z - and it would move and sort that sheet, not Andria every time.
What can I change ...![]()
Please Login or Register to view this content.
I want the macro above to run on what ever tab I have selected then I would press ctrl + z - and it would move and sort that sheet, not Andria every time.
Will the range to sort be different or the same on every sheet?
Dom
"May the fleas of a thousand camels infest the crotch of the person who screws up your day and may their arms be too short to scratch..."
Use code tags when posting your VBA code: [code] Your code here [/code]
Remember, saying thanks only takes a second or two. Click the little star to give some Rep if you think an answer deserves it.
Not sure what you mean by move but this should do the sorting and will work on whichever sheet is active.
![]()
Please Login or Register to view this content.
Dom
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks