dgt
11-19-2010, 04:38 AM
Hi all
My workbook has suddenly slowed even more than usual and I suspect from previous experience that something has happened to a particular worksheet; a cut-down sample of which is enclosed in the attachment.
The sample worksheet contains no formulas or VBA as per the original.
The row after each clients set of data, which occupy varying number of rows, should be totally blank.
e.g. Rows 8, 14, 22, 25, 33, 38, 41, 46, 51 in the attachment.
I am looking for a macro that will check each of these rows and delete any value or text within the row but not actually delete the row itself.
Bear in mind that there are huundreds more rows and columns not shown in the example but all of the same format.
Hope somebody can help with this ...David
My workbook has suddenly slowed even more than usual and I suspect from previous experience that something has happened to a particular worksheet; a cut-down sample of which is enclosed in the attachment.
The sample worksheet contains no formulas or VBA as per the original.
The row after each clients set of data, which occupy varying number of rows, should be totally blank.
e.g. Rows 8, 14, 22, 25, 33, 38, 41, 46, 51 in the attachment.
I am looking for a macro that will check each of these rows and delete any value or text within the row but not actually delete the row itself.
Bear in mind that there are huundreds more rows and columns not shown in the example but all of the same format.
Hope somebody can help with this ...David