Thanks a lot don
From: excel-macros@googlegroups.com
[mailto:excel-macros@googlegroups.com] On Behalf Of dguillett1
Sent: Wednesday, March 28, 2012 6:18 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Re: DELETE BLANK ROW AND COLUMN
Should do it.
Don
Although usually not maybe in this case deleting one row/column at a time from
the bottom up or last col to left ? Worth a try.
Sub DeleteBlankRowsAndColumnsOneAtATime()
Dim i As Long
Application.Calculation = xlManual
For i = Cells.SpecialCells(xlLastCell).Row To 1 Step -1
If Application.Cou
Dear Garcia
Its working fine but on big file like for example 6+ rows its going
into not responding state for hours, please can you do the needful to
rectify the problem.
Siraj
From: excel-macros@googlegroups.com
[mailto:excel-macros@googlegroups.com] On Behalf Of Garcia
Sent:
