S sthanawa Board Regular Joined Jul 5, 2006 Messages 80 Oct 3, 2006 #1 Hi All , I have one question . in the colume A , row 1 until row 1000 . Some cells contain string value , some cells were absolute blank. How can I delete the blank cells or delete by row up with VBA ? please suggest.