Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I've created code previously where I deleted rows based on certain
criteria being found in that row. In doing so I had the code below that did a count of rows in column a. This code assumed that there were no blank cells in column a. How would I change this code if I don't have any columns in my data where there are no blank cell?. For k = Cells(Rows.Count, "a").End(xlUp).Row To 1 Step -1 If Cells(k, "a") = "GMEIS" Then Rows(k).EntireRow.Delete Next k Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How can I test for nulls within a range without specifying each ce | Excel Discussion (Misc queries) | |||
Nulls within a .Find command | Excel Programming | |||
replace zeros with nulls | Excel Discussion (Misc queries) | |||
replace zeros with nulls | Excel Discussion (Misc queries) | |||
deaking with nulls, I think... | Excel Programming |