Can_This_Be_Don
Board Regular
- Joined
- Feb 15, 2005
- Messages
- 88
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
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