I have the following worksheet:

5 columns x ~100 rows

Already sorted by Column E in ascending order

Column E is null after the first ~10 rows.

I want to Select the range of rows where E is not null (usually abou
the first 10 rows)

I tried creating a counter in the loop that populates column E one ro
at a time then selecting it by:

Range("A1:E" & counter).Select
or by Range("A1,E" & counter).Select
then I tried Range("1:" & counter).Select etc.

This does nothing. Any help is appreciated!

Mar

--
Message posted from http://www.ExcelForum.com