.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: $$
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