Excel Macro- sort issue in Excel2003

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Radhakrishna k.v.n.r - 26 Oct 2007 08:01 GMT

Hi,

We have developed a customizd macro where we are sorting more than 5000 rows.

For a particular selection, the current region range is not getting selected
and macro is throwing "Range class failed" error while sorting.

This issue is not coming in Excel 2007.
Please help us out of this.

Reply to this Message

OssieMac - 26 Oct 2007 10:02 GMT

Hi,

First check with the particular error message is to ensure that you have the
worksheet selected before selecting the range. You cannot select a range on a
worksheet which is not the active sheet.

Regards,

OssieMac

> Hi,
>
[quoted text clipped - 5 lines]
> This issue is not coming in Excel 2007.
> Please help us out of this.

Reply to this Message