Hi Reeni,

If you want to perform the operation manually, try:

Select columnA
F5 | Special | select the 'Blanks' option | OK | Right-click | Delete |
Entire row | OK


---
Regards,
Norman


"Reeni" wrote in message
...
The problem is there is a blank
rows between blocks of data (37 blocks of data) I want to be able to
delete
the blank rows... the blank rows can vary each month...

thanks
--
Reeni