Don Guillett wrote:
with/without blanks and why
--
Don Guillett
SalesAid Software
"Rokuro kubi" wrote in message
ups.com...
How do I select the bottom half of a column's cells in a macro?
Hi Don,
The sheet is fairly uniform - there will be data in every cell in that
column until the last usedrow of the sheet. Exactly half of the
figures in column F will be duplicates and column E will be always be
one of two values. I need to lose the data directly adjacent to all
cells showing Value 2.