VBA sort

  • Thread starter Mark_F via OfficeKB.com
  • Start date
M

Mark_F via OfficeKB.com

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).EntireRow.
Delete
Range("SortedEQ").SpecialCells(xlCellTypeBlanks).
EntireRow.Delete

Any help would be greatly appreciated.
 
M

Mark_F via OfficeKB.com

Mark_F said:
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).EntireRow.
Delete
Range("SortedEQ").SpecialCells(xlCellTypeBlanks).
EntireRow.Delete

Any help would be greatly appreciated.
Click to expand...

PLEASE DISREGARD POST. PROBLEM HAS BEEN FIGURED OUT.
 
Top