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.

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

"Radhakrishna k.v.n.r" wrote:

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.