As already mentioned, sort it , Data>Sort
--
HTH
-------
Bob Phillips
"Rogue1965" <Rogue1965@discussions.microsoft.com> wrote in message
news:B5AD6276-FE70-46F3-B4D6-F278EBF8B97F@microsoft.com...
>
Subject lines in the subject line. Questions are asked in the body with MORE
explanation.
The simple answer is select>data>sort
--
Don Guillett
SalesAid Software
donaldb@281.com
"Rogue1965" <Rogue1965@discussions.microsoft.com> wrote in message
news:B5AD6276-FE70-46F3-B4D6-F278EBF8B97F@microsoft.com...
>
Just a thought - sorry not experienced enough to help much.
As this was posted in the programming forum surely the post starter would like the VBA code to do this programmatically and not as suggested by Data/Sort.
Yes, that is how to do it on the worksheet but not, i suspect, what was requested.
Please don't flame me for expressing my opinion.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks