VBA Quicky
-
I wondered if anyone may know, I just want to write a bit of VBA to put in an excel macro so that it a sheet of data, wherever a row contains a 0 in a certain column (e.g. column e), the row will be deleted. I know it would be a loop but I have never been very good on loops. So basically, e.g. it would do this Row(2)- if cell E(2) = 0 delete row, search next row, search until rows are null thanks
-
I wondered if anyone may know, I just want to write a bit of VBA to put in an excel macro so that it a sheet of data, wherever a row contains a 0 in a certain column (e.g. column e), the row will be deleted. I know it would be a loop but I have never been very good on loops. So basically, e.g. it would do this Row(2)- if cell E(2) = 0 delete row, search next row, search until rows are null thanks