XL03 Sort error: "Method 'Range' of object '_Worksheet' failed"

**AdLoki** · 07-07-2011, 05:53 AM

Hi All,

I have had to modify some code written in XL07 to be back-compatible with XL03 (thread here) but the resulting code (below) keeps falling over with a 1004 error (Method 'Range' of object '_Worksheet' failed) at the line underlined:

Please Login or Register  to view this content.

Could anyone help with this?

Many thanks,
AdLoki

**romperstomper** · 07-07-2011, 06:51 AM

Change the sort keys to:

Please Login or Register  to view this content.

and then use:

Please Login or Register  to view this content.

**AdLoki** · 07-07-2011, 08:23 AM

Thank you!! So obvious, I was staring at it for so long, couldn't see the wood for the trees!

Life saver, thanks again romperstomper

XL03 Sort error: "Method 'Range' of object '_Worksheet' failed"

LinkBack

Thread Tools

Rate This Thread

Display

XL03 Sort error: "Method 'Range' of object '_Worksheet' failed"

Re: XL03 Sort error: "Method 'Range' of object '_Worksheet' failed"

Re: XL03 Sort error: "Method 'Range' of object '_Worksheet' failed"

Thread Information

Users Browsing this Thread

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions