Sort 3 Columns in a defined range

**Parth007** · 12-26-2016, 04:36 AM

Hello Experts, need your help in sorting 3 columns..

In a range from A to I, the columns Name (Account & Type & Price) can be anywhere..
below code helps sort 2 columns (Account & Type) finding its name.. how can I add the third column (Price).. how do we modify the code.. I tried but failed on time.. please assist.

Please Login or Register  to view this content.

**kasan** · 12-26-2016, 05:46 AM

Not tested, but using same logic as for Account and Type

Please Login or Register  to view this content.

**Parth007** · 12-26-2016, 07:11 AM

Thanks a lot kasan.. worked like charm

Sort 3 Columns in a defined range

LinkBack

Thread Tools

Rate This Thread

Display

Sort 3 Columns in a defined range

Re: Sort 3 Columns in a defined range

Re: Sort 3 Columns in a defined range

Thread Information

Users Browsing this Thread

Similar Threads

Function - Count User Defined Columns in a Range

[SOLVED] If word entered not in defined name range, copy & paste it to bottom of defined name range

[SOLVED] Averaging a user input defined range based on values in columns

[SOLVED] VBA Sort Range - More than 3 Columns - Need a fourth

Count columns and rows from a defined range

[SOLVED] Copy Columns that the headers(dates) fall within a user defined date range...

[SOLVED] Macro to add defined text to the end of multiple defined columns of data

Bookmarks

Bookmarks

Posting Permissions