Hi,

I am relatively new to macros, and need help with regard to selecting rows
in Excel.

1. I currently have a macro which sorts a pre-defined range of 100 rows.
However there is only data in about 50 of these rows (although this exact
figure varies. On certain days there will be 60 rows, but never more than 100
rows).

2. The macro then copies the sort range and pastes the values elsewhere.

The problem is that one of the sort criteria is a field that contains both
numbers and text. So the result of the macro is (e.g.) 25 rows of numbers,
then 50 rows of blank space, and then 25 rows of text.

What I need the macro to do is (in step 2. above) only select rows that
contain data, so that the pasted values data will only contain 50 rows of
data, rather than 100.

I am sure there is an easy way to do this using countloop or something, but
I am not experienced to know how to use this.

Any suggestions would be much appreciated.

Thanks