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
 
Thank You ,Ritchie I have got my results.


Raj Bharath
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Count latest number of continous not-empty cells in a row. 11
Deleting specific information 3
delete the non blank rows depending on Column 1
Excel Help to copy information from one row at a time to another sheet 1
Delete Blank Cells in a Row 6
Delete rows based on contents of Col A 0
MACRO TO DELET ROWS DEPENDING ON CELL VALUES 6

Back
Top