Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Deleting rows based upon the value in column D
Hi, I would like to delete all rows in my spreadheet that have a non-numeric
or null value in column D. The length of my spreadsheet will vary in length and there is no column headings in the spreadsheet, just pure data from row A onwards. Thanks in advance. Sean |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Deleting rows based upon the value in column D
On Error Resume Next
columns(4).SpecialCells(xlConstants,xlTextValues). EntireRow.Delete columns(4).SpecialCells(xlBlanks).EntireRow.Delete On Error goto 0 If the values are produced by formulas you can use xlFormulas,xlTextValues if you have error values xlFormulas,xlErrors or Logical xlFormulas,xlLogical See help on special cells for other options. -- Regards, Tom Ogilvy "Sean" wrote in message ... Hi, I would like to delete all rows in my spreadheet that have a non-numeric or null value in column D. The length of my spreadsheet will vary in length and there is no column headings in the spreadsheet, just pure data from row A onwards. Thanks in advance. Sean |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Deleting rows based upon the value in column D
very nice, I was able to consolidate the following three lines recorded, into one. Columns("B:B").Select Selection.SpecialCells(xlCellTypeBlanks).Select Selection.EntireRow.Delete Thanks, To -- ackur ----------------------------------------------------------------------- ackurv's Profile: http://www.excelforum.com/member.php...fo&userid=1552 View this thread: http://www.excelforum.com/showthread.php?threadid=27204 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Deleting Rows based on a Value | Excel Worksheet Functions | |||
Deleting rows based on column values | New Users to Excel | |||
Deleting Rows based on Column Critieria | Excel Discussion (Misc queries) | |||
Deleting Rows based on text in cell & formatting cell based on text in column beside it | Excel Programming | |||
Deleting rows based on criteria | Excel Programming |