Tashi has attended:
No courses
Delete row if a cell in a column is blank
What is the macro to delete a row if a cell in a specific column is blank? Is there a way to do this without using macros or doing it manually?
RE: Delete row if a cell in a column is blank
Can you please clarify cell in a column is blank?
thanks
paul
RE: Delete row if a cell in a column is blank
By blank cell, I mean a cell with nothing entered into it. It does not have a value of 0
RE: Delete row if a cell in a column is blank
how many rows are using the column? ie, are there 20 rows and if 1 cell out of 20 is blank you want to delete the entire column?
RE: Delete row if a cell in a column is blank
There are 300 rows. If the cell in column C is blank ( i.e. no data entered) for that row I want to delete the entire row that includes the blank column C cell. It's a very simple table. There is a possibility that afterwards I will want to repeat the process but with a different column.
RE: Delete row if a cell in a column is blank
it really depends on how often you are going to run this delete operation. If its every now and then I would suggest you simply put a filter on the header, filter the non blanks and then delete them manually. You can create a macro for this but that gets a bit more complicated.
Does that help?
