Run-time error when trying to sort a range

[g8r777]

Hello all.

I am trying to sort a range within a range and keep getting a runtime error that I can't seem to fix.

Here is my code:

Please Login or Register  to view this content.

I have a range that has a blank row at the top and bottom. I need to keep these blank rows so sorting the whole range won't work.

The "Set rng" and "rng.Select" code work properly.

Now I want to sort the newly selected subrange by the first column (which holds dates) in ascending order (oldest to newest).

With the code I have, I get a '1004' run-time error which states "Method 'Range' of object '_Global' failed.

This is a new one for me.

Any help is appreciated.

Thank you,

Brian

[shg]

Maybe ...

Please Login or Register  to view this content.

[g8r777]

This code gives the same '1004' error but now says "Application-defined or object-defined error" and highlights the following line of code:

Please Login or Register  to view this content.

[g8r777]

Fixed it.

Please Login or Register  to view this content.

Using "Range(rng(1, 1))" for the sort key was the problem.

[shg]

Corrected in prior post (the big red dot).