remove lines if a cell is blank

Thanks, sorry but can it be activated from the current sheet and continue to next sheet, rather than the entire workbook?
I have some statistical data in a number of sheets at the front that may/may not have data at E86.

thanks

Hey I thought it was working, but I get an error message.
"error: Application-defined or object-defined error"
Obviously there is something wrong. Any chance of fixing it for me?
thanks

There is too much data to remove for me to provide a sample.
Can you provide me with a simpler version that is more like a macro?
go to E86, if blank delete row 86, go to next sheet

then repeat the process?

Your solution does not work, should it be clear contents or delete row in the script???


I've uploaded a sheet, macro enabled. My real data has over 300 sheets.

Hey, christopher try using:

Please Login or Register  to view this content.

This should delete the row like I think you are intending to.

I've replaced the line with your text aloha31, but it does not work. Running the debug it identifies the End If as an issue. When I read the script it says go to E86, if empty delete entire row, then end if ....... but what does it do if the cell has data? It needs to check the cell at E86 and continue deleting (mostly only once), until E86 contains data, then go to the next sheet and repeat the process. Some sheets will have data in the cell, some won't. Can you fix the script using the file I uploaded?

We have victory !!! Thanks heaps. This will save me hours - seems to be working fine now. Excellent work, it is easy when we understand the questions and tasks to perform, sometimes it is difficult to communicte via written word. But this is good stuff. thanks again.