View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
tbmarlie tbmarlie is offline
external usenet poster
 
Posts: 26
Default Count of rows with nulls

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