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
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