View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Steven R. Berke Steven R. Berke is offline
external usenet poster
 
Posts: 8
Default Eliminating rows of data in excel spreadsheet that have blank cell in row A and data in row B - E

I have several rows of data at the bottom of an excel file that I want
to delete. These rows consist of 5 columns of data but in the case of
the rows I want to delete there is no data in cell A. This feature
only exists in the cells of the rows I want to delete all the other
rows have data in column "A". What I need is a macro that will delete
the rows that have blank cells in row "A" but have data in row "B"
thru "E".