Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA sort
Greetings, all.
As you can see by the VBA below, I'm deleting empty cells out of named ranges. After the VBA for "SortedEE" executes, the cells in "SortedEQ" get moved up into the range for "SortedEE" and some of my data gets deleted. I thought because I was using a reference to a name that I could have both name ranges be sorted and have the empty cells deleted. Is my sorting the problem? I figured the source of my problem might be VBA below. VBA Example: Range("SortedEE").SpecialCells(xlCellTypeBlanks).E ntireRow. Delete Range("SortedEQ").SpecialCells(xlCellTypeBlanks). EntireRow.Delete Any help would be greatly appreciated. -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...mming/200908/1 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA sort
Mark_F wrote:
Greetings, all. As you can see by the VBA below, I'm deleting empty cells out of named ranges. After the VBA for "SortedEE" executes, the cells in "SortedEQ" get moved up into the range for "SortedEE" and some of my data gets deleted. I thought because I was using a reference to a name that I could have both name ranges be sorted and have the empty cells deleted. Is my sorting the problem? I figured the source of my problem might be VBA below. VBA Example: Range("SortedEE").SpecialCells(xlCellTypeBlanks).E ntireRow. Delete Range("SortedEQ").SpecialCells(xlCellTypeBlanks). EntireRow.Delete Any help would be greatly appreciated. PLEASE DISREGARD POST. PROBLEM HAS BEEN FIGURED OUT. -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...mming/200908/1 |
Reply |
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 function for dates does not sort properly in Office 2007 Exc. | Excel Worksheet Functions | |||
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) | |||
sort (on part of) string - originally posted under Tricky Sort | Excel Programming |