| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel sort vs VBA
This is part of a sequence that was sorted in ascending order in Excel...
Ad Spend - Arbeitsagentur - Press () Ad Spend - Arbeitsagentur - Trade Magazines/Press ($) Ad Spend - Arbeitsagentur - Trade Magazines/Press () Ad Spend - Arbeitsagentur (Group Label) Ad Spend - Cadremploi - Online ($) Ad Spend - Cadremploi - Online (£) When running a loop in VBA, the value in the 4th line is less than the value in the 3rd. Why did is this so? Is there a way of comparing cells so that the hireachy is the same as Excel uses for sorting. Currently I am using.. if range(CellAdress).value < range(CellAdress.offset(1,0)).value then... |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Updating workbook with an alpha sort sheet and a numeric sort shee | Excel Discussion (Misc queries) | |||
| Sort from SQL view does not sort in EXCEL | Excel Discussion (Misc queries) | |||
| Pls. reply Sort Data and copy to next coulmn when sort order chang | Excel Programming | |||
| Excel sort by Fill Color by custom list sort | Excel Discussion (Misc queries) | |||
| Excel Sort function should not sort the cell formatting! | Excel Worksheet Functions | |||
Threaded Mode
