Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2000 VBA - Selecting populated range
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2000 VBA - Selecting populated range
Range("E1",Cells(rows.count,5).End(xlup)).offset(0 ,-4).Resize(,5).Select
-- Regards, Tom Ogilvy "sub_pop " wrote in message ... 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 about the first 10 rows) I tried creating a counter in the loop that populates column E one row 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! Marc --- Message posted from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
find last populated cell in range of cells | Excel Worksheet Functions | |||
Find the first or last populated column in a range | Excel Worksheet Functions | |||
excel 2007- when selecting a range to edit, it has no highlight | Excel Discussion (Misc queries) | |||
LookUp to Display Last Value Populated a in Range | Excel Worksheet Functions | |||
Populated Cells In A Named Range | Excel Programming |