Re: $$Excel-Macros$$ how to delete multiple row & columns

2011-08-23 Thread dguillett1
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

Re: $$Excel-Macros$$ how to delete multiple row & columns

2011-08-23 Thread STDEV(i)
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

RE: $$Excel-Macros$$ how to delete multiple row & columns

2011-08-23 Thread Amit Desai (MERU)
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

Re: $$Excel-Macros$$ how to delete multiple row & columns

2011-08-24 Thread dguillett1
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