RE: $$Excel-Macros$$ DELETE BLANK ROW AND COLUMN

responding state Siraj From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of NOORAIN ANSARI Sent: Tuesday, March 27, 2012 6:27 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ DELETE BLANK ROW AND COLUMN Dear Siraj, Please try it

Re: $$Excel-Macros$$ DELETE BLANK ROW AND COLUMN

Thanks,but it only delete blank row and column,but not delete entire row and column. 111 111 111 after run,it be 111 111 111 not 111 111 111 please check. On Tuesday, March 27, 2012 10:27:13 AM UTC+8, NOORAIN ANSARI wrote: > > Dear Siraj, > > Please try it.. > >

Re: $$Excel-Macros$$ DELETE BLANK ROW AND COLUMN

Dear Siraj, Please try it.. Sub delete_blankrowColumn() Cells.SpecialCells(xlCellTypeBlanks).Rows.Delete Cells.SpecialCells(xlCellTypeBlanks).Columns.Delete End Sub -- Thanks & regards, Noorain Ansari *http://noorainansari.com/* *http://excelmacroworld.blogspot.com/*

$$Excel-Macros$$ DELETE BLANK ROW AND COLUMN

Dear Friends I need to delete blank row and blank column from the attached file with the help of macro because data is large. Thanks Siraj -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help,