LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3,290
Default Sorting in Ascending Order


On the Edit menu in the VBE choose "Replace" and...
Replace all instances of xlDescending with xlAscending
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)



"Diana Bowe"

wrote in message
Attached is the visual basic coding for the macro which creates a journal
entry for upload. I need to sort this in ascending order because descending
order is causing an intercompany nightmare (as we do not consolidate the
higher numbered companies). How can I change the code to sort in ascending
order?
-snip-
 
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 a Column in ascending order in excel vba yogeshyl Excel Programming 2 December 12th 07 07:28 AM
Sorting Data in ascending order sharon2006 Excel Discussion (Misc queries) 1 March 14th 06 01:07 AM
sorting number in ascending order Janice Lee via OfficeKB.com Excel Discussion (Misc queries) 2 April 8th 05 10:31 PM
Ascending Order Michael168[_71_] Excel Programming 3 April 5th 04 04:16 PM
Sorting into Surname order (alphabetically ascending) Mark Excel Programming 1 January 6th 04 01:03 PM


All times are GMT +1. The time now is 04:48 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"