Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to delete the content of Excel cells from VBS script? | Excel Discussion (Misc queries) | |||
need macro script - repeat to delete 2 rows | Excel Discussion (Misc queries) | |||
How to delete a set of rows depending on Value | Excel Discussion (Misc queries) | |||
Delete row depending on criteria | Excel Discussion (Misc queries) | |||
what is a vb script | Excel Programming |