Tech Support Guy banner
Status
Not open for further replies.

Deleting rows based on empty cell.

898 views 2 replies 2 participants last post by  bomb #21 
#1 ·
You must be bored with this question cos I've seen lots of them, however I can't seem to fathom out what to do..........

I've got a block of data within a spreadsheet 4 rows always in the same place.

How do I put into code:-

If column d43:e46 is blank delete rows 43 - 46 if not ignore it.

As I said I've tried a few things and it will delete the four rows regardless of them being empty of not.

Can someone help please.

Many thanks,

Moll
 
Status
Not open for further replies.
You have insufficient privileges to reply here.
Top