View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
MYR MYR is offline
external usenet poster
 
Posts: 2
Default deleting rows with blank cells after a specified column?

Hello. I have a question regarding row deletion. Is there a macro
that allows me to delete entire rows if all cells beyond a specified
column are blank?

For example, if cells in row 5 are all blank after column C, how do I
delete that entire row (and all rows like that in the entire
spreadsheet)? If there is data in any one or more cells after column
C, I do not wish to remove that row. I appreciate your help.