Hi, trying to sort by cell color and want to select areas to be sorted with mouse and then run the sort routine:
I get an Picture1.png error related to this line of the code:
Please Login or Register to view this content.
I'm sure something simple I'm missing.Please Login or Register to view this content.
Hi Bob- SelRange is a range OBJECT, so you don't need the Range method, just use the variable name.Please click the Add Reputation star below any helpful posts, and use Thread Tools (up top) to mark your thread as SOLVED once you have your answer. Thanks!-LeePlease Login or Register to view this content.
Last edited by leelnich; 08-09-2017 at 02:11 PM.
Ahh!
Thanks very much!
You're most welcome! If complete, please mark your thread as SOLVED (Thread Tools, up top) - Thanks Lee
BTW, I just updated the code (a little tighter).
Please click the Add Reputation star below any helpful posts, and use Thread Tools (up top) to mark your thread as SOLVED once you have your answer. Thanks!-Lee
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks