Help needed with a sorting procedure on an array - Subscript out of range

[seigna]

I am working on the following code, which is supposed to get the values from a spreadsheet into arrays, sort them (it's a triple sort here - three arrays are sorted at once), and finally place the results in another sheet...

The problem is I get a Subscript out of range" error message and I really don't know how to fix it
I seem to have this problem EACH time I try sorting an array.. so there must be something wrong with the Sort ... (it is called TriFonds here)

Any help will be greatly appreciated..

Please Login or Register  to view this content.

[seigna]

I updated the code.. now it returns a type mismatch error.. before it gave zeros everywhere

Please Login or Register  to view this content.

[seigna]

I have updated the worksheet with the code..

[seigna]

Anyone a clue ? Im getting desperate with this, I changed the code so many times :'( :'(

[Norie]

The type mismatch is because one of the columns you are dealing with is full of strings.

Actually I would suggest you declare the various arrays as Variant.

By the way, why aren't you using Excel's built-in sort?

[seigna]

I could have but the project I am working on requires to type up my own code... but if worst comes to worst I'll just do that..

And I did change the arrays to Variant but it didn't help - It came back to subscript out of Range error :'(

[seigna]

I've gotten this far.. and now I have no clue what next ... :/

[seigna]

I'm going to try the excel sort.. this is just strange..