How to delete a row depending on a script
 

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

How to delete a row depending on a script
 

Hi Raj,
Is this what you mean?

On Error Resume Next ' In case there are no blanks
Columns("A:A").SpecialCells(xlCellTypeBlanks).Enti reRow.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
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Raj Bharath" wrote in message ...
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

How to delete a row depending on a script
 

Thank You ,Ritchie I have got my results.


Raj Bharath

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!