Beatrix. ----- the last code i posted deletes rows of blank cells in Column A, and deletes columns of blank cells in the First Row and does not "Delete blank rows and columns in range" since range can be (assuming FR = 13 / LR = 180 / LC = 10) "A13:J180". if A20 is blank, row 20 will be deleted regardless of other cells being non blank in the same row. is E25 is a blank cell but A25 is not, row 25 will not be deleted because only Col A is taken into account for row deletion. ----- if bolded bit in your last post is what you need, the code does not work for you and must be modified.