Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Delete a ROW in EXCEL
Dude, how to delete a row if the entire row is empty in Excel ? i got many row empty in between .. like there are about 50 rows an every4 th , 15th and 20th row is empty . how to delete it with a single code -- jayender.v ----------------------------------------------------------------------- jayender.vs's Profile: http://www.excelforum.com/member.php...fo&userid=2864 View this thread: http://www.excelforum.com/showthread.php?threadid=48345 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Delete a ROW in EXCEL
EditGo to,Special, select Blanks
EditDeleteEntire row -- Kind regards, Niek Otten "jayender.vs" wrote in message ... Dude, how to delete a row if the entire row is empty in Excel ? i got many row empty in between .. like there are about 50 rows and every4 th , 15th and 20th row is empty . how to delete it with a single code? -- jayender.vs ------------------------------------------------------------------------ jayender.vs's Profile: http://www.excelforum.com/member.php...o&userid=28640 View this thread: http://www.excelforum.com/showthread...hreadid=483450 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Delete a ROW in EXCEL
That would be (or like) if you can base the deletion on one column.
You certainly would not want to select all cells in a worksheet and delete any row that has a empty cell within the used range. If you want to delete all rows that are entirely empty based on COUNTA use the macro at http://www.mvps.org/dmcritchie/excel...emoveEmptyRows --- 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 "Niek Otten" wrote ... EditGo to,Special, select Blanks EditDeleteEntire row "jayender.vs" ... how to delete a row if the entire row is empty in Excel ? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do i delete a macro in Excel 2003 when delete isn't highlight | Excel Discussion (Misc queries) | |||
Macro to delete sheets and saves remaining file does not properly delete module | Excel Programming | |||
Macro to delete sheets and saves remaining file does not properly delete module | Excel Programming | |||
Macro to delete sheets and saves remaining file does not properly delete module | Excel Programming | |||
Delete every 3rd row, then delete rows 2-7, move info f/every 2nd row up one to the end and delete the row below | Excel Programming |