| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sorting range multiple areas
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Multiple plot areas | Charts and Charting in Excel | |||
| Multiple Print areas in same sheet? | Excel Discussion (Misc queries) | |||
| Set Multiple Print Areas | Excel Discussion (Misc queries) | |||
| Sorting range with areas | Excel Programming | |||
| Sorting range multiple areas | Excel Programming | |||
![Dave Peterson[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
