With a range that the number of rows will vary and the number of columns will vary I want to do this:
For each row in range if row cell/s = blank then move row to top of range, next row.
Where "cell/s" would be a cell or a few cells but not a completely blank row.
End results would look like this:
First row with blank cell would be first row of new range, 2nd row with a blank would the next until all rows with a blank are at the top of the range and all rows without a blank are below in the order they originally were.
Title says I want code but if Excel sort functions can do this that seems okay with me.
Thanks.
Howard
For each row in range if row cell/s = blank then move row to top of range, next row.
Where "cell/s" would be a cell or a few cells but not a completely blank row.
End results would look like this:
First row with blank cell would be first row of new range, 2nd row with a blank would the next until all rows with a blank are at the top of the range and all rows without a blank are below in the order they originally were.
Title says I want code but if Excel sort functions can do this that seems okay with me.
Thanks.
Howard