Thanks to Alf Bryn, Don Guillett and Ron de Bruin for your help - very
much appreciated. Unfortunately, these macro codes worked but did not
delete all the rows that had blanks in column A.

Alf's code worked the best but I had the following problem:

At the moment I have 6 rows of data that I wish to keep and each of
these rows contains data in column A. However, in column S and Y, I
have approximately 60,000 rows of data that has no data in their
corresponding column A. As this is a dynamic spreadsheet (it gets
larger over time) I need to delete all rows that contain data in columns
S and Y but have no data in column A.

With Alf's code, what happened was that when the code applied to row 7
(first blank row in column A) it deleted OK. However, after it deleted
this row, the row became "A7" again and again... and consequently the
code did not continue deleting as it contined its loop to row 8, 9, 10
...

If anyone can please help that would be great.

Kind regards,

Longbow :-)

Live Long and Prosper :)

*** Sent via Developersdex http://www.developersdex.com ***