Problem Deleting Cells

[Can_This_Be_Don]

Have set up a user form that allows me to add records to a spreadsheet. Sometimes the new record button is hit and no data is actually input. Even so this creates a record on the spreadsheet.

If I use the filter button this shows the blank row and I can delete the record. As I need to automate the procedure I've tried using various suggestions I've found on the forum but they do not seem to work.

The last piece I found suggested using this code:

Columns("I:I").SpecialCells(xlCellTypeBlanks).EntireRow.Delete

This does not seem to delete the blank records as an error comes up saying "No cells were found" even though they appear using the filter.

Can anyone please help. :x

Don

 

[Nimrod]

what Colmn are the blanks located in ?? What Column are you using to filter by ... is the entire row blank ? If the entire row is blank why are you attempting to delete it ?

 

[Can_This_Be_Don]

Resolved the problem.