Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
IsEmpty on a range/array
One way:
Dim rLastCell As Range Set rLastCell = Range("A" & Rows.Count).End(xlUp) In article , "benb" wrote: I need to find the last row of a column that still contains data. I cannot use Do While Not IsEmpty (or something similar) because there are blank cells mixed into the column. The best solution I can come up with is finding the cell at which the 20 or so cells above contain data and the 20 or so cells below are empty. The problem: IsEmpty does not seem to work in evaluating a range. How can I evaluate if Cells(1,1) to Cells(20,1) contain data while Cells(21,1) to Cells(40,1) are empty? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Do.....Loop until IsEmpty(....) | Excel Programming | |||
Help with IsEmpty | Excel Programming | |||
isempty | Excel Programming | |||
vba: isempty | Excel Programming | |||
Problem with IsEmpty Function | Excel Programming |