array question
was wondering if this was possible using an array.
i have lastrow set to i
i would like to set a variable to either column "A", "b" or "C" (col below)
so if any of the 3 columns in row i are blank, the row is deleted.
i know i can write some if's to handle it, just trying to gain some
practice with arrays.
linecount just tells me how many rows were deleted
col = (Array("A", "B", "C")) (i know this is wrong, just an example)
For i = lastrow To 1 Step -1
If Array(Cells(i, col)) = "" Then
Cells(i, col).EntireRow.Delete
LineCount = LineCount + 1
End If
Next
--
Gary
|