Dear Noorain
I want to delete the complete row and column if it is completely blank after deleting row the data in the next column or row should not be shifted to the delete row or column, please do the need full, Garcia macro is working but on big file like 60000+ row its going into not 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.. 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/ <http://excelmacroworld.blogspot.com/> On Mon, Mar 26, 2012 at 5:46 PM, Siraj Momin (BTG) <smo...@ccc.ae> wrote: 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, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. ------------------------------------------------------------------------ ------------------------------ To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. ------------------------------------------------------------------------ ------------------------------ To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. ------------------------------------------------------------------------------------------------------ To post to this group, send email to excel-macros@googlegroups.com
