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

2011-08-22 Thread Rajan_Verma
.Count).End(xlToLeft).Column Cells(1, LastDataBased).Resize(1, LastCol).EntireColumn.Delete End Sub From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Amit Desai (MERU) Sent: Tuesday, August 23, 2011 12:02 PM To: excel-macros@googlegroups.com Subject: $$

$$Excel-Macros$$ how to delete multiple row & coulmns

2011-08-22 Thread Amit Desai (MERU)
Dear All, Please let me know how to delete multiple rows(say from my last data based row # 678 to last row) & multiple columns (say from AA to last column). This is taking a lot of file size... Best Regards, Amit Desai Disclaimer: This message and its attachm