I wish to loop through each row of a set area of a worksheet and delete only those rows which have nothing stored, regardless of whether they have never been used, or, if they once had contents in a cell/s that have since been cleared. If any cell in the row has had its formatting altered or anything, I still wish it to be considered empty; as long as there is no formula or entry in a cell, I want it detected to be deleted.1. My text has the line
If IsEmpty(Range("A1")) then ....
which will test only if a particular cell is empty.
If I try
If IsEmpty(rows(1)) then
there is no compile error, but, if row 1 (1) has nothing in any cell, it still won't match if I have nothing in row 1 of the worksheet.
2. What is the difference between somthing being empty or something being null? I have tried other codes with null to try to detect empty lines, but they've caused run errors or again logical ones.
Many thanks to anyone who can assist :-)