Hi,
I have following Code in a macro
In this currently the sort range and each collumn range is fixed but I would like to replace it by a user selectable range. What code I should insert.Please Login or Register to view this content.
thanks
Hi,
I have following Code in a macro
In this currently the sort range and each collumn range is fixed but I would like to replace it by a user selectable range. What code I should insert.Please Login or Register to view this content.
thanks
Last edited by sacash; 01-16-2018 at 02:47 AM.
Hi
Please fix your closing tag before we can assist you. It should be a [/CODE] tag and not [END CODE].
Don
Please remember to mark your thread 'Solved' when appropriate.
Thanks.
You can use Application.inputbox(type:=8) to allow the user to select a range.
and how will it change the code posted above?
That depends on how you decide which columns to sort by.
all the columns which are stated in the code needs to be sorted from high to low. but range will be user selected by Input box
So you'll need to validate the selected range first to ensure it actually includes columns H to N as a minimum?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks