you are a little vaque about what's in the range and why
it is busted up so much. and why it "could be of diffeent
are selections."
as to the generic mocro, i know of no such thing.
Computers are incredibly stupid. you have to tell them
everything. when i write a macro, the compiler starts
getting picky about everything. i don't think you have
given enough info to help out.
-----Original Message-----
Hi

I have a range which could be of different area
selections.

For example rng1 address could be $A$37:$D$38 or
$A$25:$D$26,$A$43:$D$47 or

$A$48:$D$49,$A$57:$D$57,$A$63:$D$63.

I gets the error when there are multiple areas such as
$A$25:$D$26,$A$43:$D$47
but its works fine where are only one area such as
$A$25:$D$26.
The error msg I get "The command you
chose cannot be performed with multiple selection. Select
a single range and
click the command again"


Can somebody help me out to write a generic VBA macro to
sort the range
according to column 1?

Help would really be appreciated.

In my previous posting, I didnt get my answer but by
mistake i pressed Yes
btn, Sorry for that.

Thanks and regards,


.