See one more reply at your other post.

VJ wrote:

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,

--

Dave Peterson