Excel Macro- sort issue in Excel2003

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

macro to sort is missing top row out??? 4
Excel2003 vs 2007 ... :( 2
writing a sort macro 2
Ending in Macros 4
Sorting Macro 4
Conditional formatting on a dynamic range - workaround 1
Macros Automatically Sort 5
sort part of a filtered spreadsheet 1

Back
Top