Sorting certain ranges in a worksheet

[ymmotteov]

Hi all,

I use the following code for sorting named ranges by hour. But it sorts all the ranges in the worksheet and I only want the ranges that start with 'mission'.

Can the

Please Login or Register  to view this content.

be changed so that it only sorts the ranges in the workbook that start with mission?

Please Login or Register  to view this content.

[xlnitwit]

Perhaps this

Please Login or Register  to view this content.

[ymmotteov]

That seems to do the job but gives an error on the following line below.


Set ListRng = LijstWks.Range("A2").Resize(R - 1, 2)

Any idea why?

[xlnitwit]

You didn't delete the R = 2 line at the start by any chance, did you?

[ymmotteov]

No, it's still there...

[xlnitwit]

What is the error message?

[ymmotteov]

I had to translate it but this should be the error message:

Error 1004 "Application-defined or Object-defined error"

[xlnitwit]

Then I think that none of your named ranges start with "mission". If that were the case, you'd start with R = 2 and never increment it. Then there is an R = R - 1 line (so R = 1) and finally you try to resize a range to be R - 1 rows and of course you cannot have a 0 row range.

[ymmotteov]

Tried it again a couple of times and eventually it worked. I left the 'LCase' out. I probably made a mistake somewhere, but it's perfect now!

Thanks!