Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 6
Default Sorting multiple columns in VBA

"Tom Ogilvy" wrote:

With your sample date run this:
Sub Macro7()
Columns("B:B").Select
[..]
Range("A4").Select
End Sub
Use this concept to fix you problem (cut the columns you don't want sorted,
sort the data, cut the columns not sorted back to their original locations )


I somewhat hoped there would be an easier way to make the Excel sort
function behave the way I want, but your technique works fine too. "Dick
Kusleika" posted another method I'll take a closer look at. It seems to
me the best solution at this point.

Thanks Tom, Dick and gocush for your input!

--
mahi
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
sorting multiple columns arbe Excel Worksheet Functions 2 February 17th 10 09:36 PM
Sorting Multiple Columns - L Brandon Excel Discussion (Misc queries) 2 April 22nd 08 01:32 AM
sorting multiple columns Amstro2006 Excel Worksheet Functions 5 November 7th 07 10:07 PM
Sorting in multiple columns jezzica85 Excel Discussion (Misc queries) 2 February 20th 06 11:17 PM
Sorting multiple columns together sweetledee Excel Discussion (Misc queries) 4 August 23rd 05 10:19 PM


All times are GMT +1. The time now is 12:25 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"