How to alphabetically sort values in a dynamic range?

[max3732]

I have 2 columns of data, the 1st has names and the second has numbers. I'd like to sort the data alphabetically then get rid of the duplicate name in the name column and move the numbers over a column.

I tried recording a macro using the sort in excel and when I put in the range I had set it gave an error (subscript out of range on the 2nd line that starts with "ActiveWorkbook").

I checked the variable "SortRng" and it does refer to the 2 columns and rows I want. Here is the relevant code and an example of the kind of data I'm working with.

Please Login or Register  to view this content.

[patel45]

Please Login or Register  to view this content.

changed after HaHoBe advise

[HaHoBe]

Hi, max3732,

if you have more than one item to be listed patel45īs code will fail as only one cell is copied over (wiull always copy Column B to Column C no matter what information is on that line).

First suggestion is to combine the contents in Column B:

Please Login or Register  to view this content.

Second would be to add the cells to the right of the first line the item appears on:

Please Login or Register  to view this content.

In your code sample you mention SortRng which depends on SortSt which isnīt defined. You should make sure to include this information for us if you post a procedure which is causing trouble.

Ciao,
Holger

[shyamhappy]

[shyamhappy]

[apo]

Hi..

Here's another..

Please Login or Register  to view this content.

[HaHoBe]

Hi, shyamhappy,

whatīs the use to post the code of another user twice into this post without any additional information? And why use HTML-tags instead of code-tags?

@apo:
you would need to dim

Please Login or Register  to view this content.

for making the code work in an Option Explicit environment.

Ciao,
Holger

[apo]

@HaHoBe..

You got me on that one.. I went back and 'thought' i had Dimensioned them all before posting..