8192 areas error message

[sindhuja]

Copy to worksheet


There are more than 8192 areas: It is not possible to copy the visible data
TIP: sort your data before you use this macro.


Can someone assist me to clear the above error. Please let me know how to resolve this issue.

Immediate attention will be highly apprecaited.

-sindhuja

[Aflatoon]

Perhaps do as suggested and sort your data by whatever field(s) you are filtering.

[sindhuja]

tried the same.. but same error message again :( :(

[Aflatoon]

Then, assuming you did it correctly, you have too much disparate data to use the code you are trying to use.