ros@googlegroups.com
Subject: RE: $$Excel-Macros$$ how to delete multiple row & columns
Thanks a lot for the solution. Can you tell me how shall I use this? I mean How
shall I paste this code so that macro works.. & hope it will delete only blank
oups.com] On Behalf
Of STDEV(i) [setiyowati.d...@gmail.com]
Sent: Wednesday, August 24, 2011 6:29 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ how to delete multiple row & columns
A little correction
Sub cleanrowsandcolumnsSAS()
lr = Cells.Find("*", Cells(Row
A little correction
Sub cleanrowsandcolumnsSAS()
lr = Cells.Find("*", Cells(Rows.Count, Columns.Count) _
, , , xlByRows, xlPrevious).Row *+ 1*
lc = Cells.Find("*", Cells(Rows.Count, Columns.Count) _
, , , xlByColumns, xlPrevious).Column *+ 1*
Application.EnableEvents = Fal
If I understand your request, you may like this. It also saves the file
Sub cleanrowsandcolumnsSAS()
lr = Cells.Find("*", Cells(Rows.Count, Columns.Count) _
, , , xlByRows, xlPrevious).Row
lc = Cells.Find("*", Cells(Rows.Count, Columns.Count) _
, , , xlByColumns, xlPrevious).Column
Application.Ena