How to delete a row depending on a script

  • Thread starter Thread starter Raj Bharath
  • Start date Start date
R

Raj Bharath

I want to delete some Rows, from a group of data,
depending on a cell[Of a particular column] which is empty
among the group. Could anyone help me out on this issue.



Thank You,
Raj Bharath
 
Hi Raj,
Is this what you mean?

On Error Resume Next ' In case there are no blanks
Columns("A:A").SpecialCells(xlCellTypeBlanks).EntireRow.Delete
ActiveSheet.UsedRange 'Resets UsedRange for Excel 97

more information in
Delete Cells/Rows in Range, based on empty cells, or cells with specific values
http://www.mvps.org/dmcritchie/excel/delempty.htm
 
Back
Top