Cathal,

Hard to say without knowing where the blank cells are and what you want to
happen once they are deleted (which way to shift cells).

One thing you can do is turn on the macro recorder to see the code that
Excel generates. For example, if you wanted to select and delete all the
blank cells in column E, turn on the macro recorder (Tools Macro Record
Macros), then select column E, and go to Edit Go To Special. Then
select "Blanks" and hit OK. Then go back to Edit and select Delete. Once
you stop the macro recorder and look at the code, you see that you get
something like this

Sub DeleteBlanks()
Columns("E:E").Select
Selection.SpecialCells(xlCellTypeBlanks).Select
Selection.Delete Shift:=xlToLeft
End Sub

Patti



"CPower " wrote in message
...
This is great patti thanks a mil, now i need a way to delete the blank
cells, if u can help that would be great.

Thanks,
Cathal.


---
Message posted from http://www.ExcelForum.com/