Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Array Question | Excel Discussion (Misc queries) | |||
Array Question | Excel Worksheet Functions | |||
Array Question | Excel Programming | |||
Array question | Excel Programming | |||
Array Question | Excel Programming |