if a range should always be sorted as a group, is it possible to specify that
and thus stop a part of the range from being selected and sorted ?
if a range should always be sorted as a group, is it possible to specify that
and thus stop a part of the range from being selected and sorted ?
do you mean from a macro and from a specific range...
if not,
then you must referring to a dynamic range............
You could *pre*select your ranges ahead of time and assign them names,
something like "srt1", "srt2", etc.
When it comes time to perform the sort, click in the name box and pick the
one you want, which then becomes selected and ready for sorting, excluding
everything else.
--
HTH,
RD
---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Craig" <Craig@discussions.microsoft.com> wrote in message
news:C0F7CEA4-CFA9-423B-AC45-055B083D64E5@microsoft.com...
> if a range should always be sorted as a group, is it possible to specify
that
> and thus stop a part of the range from being selected and sorted ?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks