Hello,
I am trying to learn rules in altering a macro that has been recorded. I need the following code to execute across columns A-AX. Thank you in advance for your time.
![]()
Please Login or Register to view this content.
Hello,
I am trying to learn rules in altering a macro that has been recorded. I need the following code to execute across columns A-AX. Thank you in advance for your time.
![]()
Please Login or Register to view this content.
Hi Lucasdylan,
Try: Range("A2:AX21")
If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)
You can't do one thing. XLAdept
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin
Hello xladept:
Thank you for the response. The change you suggested works, but I need the columns to be sorted independently. Right now it seems they are all being sorted on the numbers in column A. Any thoughts? Thanks again.
Hi lukasdylan,
Maybe:
![]()
Please Login or Register to view this content.
Hi lukasdylan,
Get rid of that select at the end of the set - sorry.
Alternate version, using Range.Sort instead of Worksheet.Sort:
![]()
Please Login or Register to view this content.
Hope that helps,
~tigeravatar
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks