Excel 2000 VBA - Selecting populated range

[sub_pop]

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

 

[Tom Ogilvy]

Range("E1",Cells(rows.count,5).End(xlup)).offset(0,-4).Resize(,5).Select