Purge / Delete Unused rows and Columns in Excel 2007 and copy Column
Posted on 2010-01-07
Can you tell me how you purge / delete all unused columns and rows in Excel 2007 please?
I have a worksheet where I want to copy and insert a column and I use this code
Range("SortContacts").Offset(0, 1).EntireColumn.Insert Shift:=xlToRight
The second line seems to take a very long time to execute and I am assuming (perhaps wrongly) that its something to do with the increased number of columns in 2007?
Also if you pull the tab on the horizontal scroll bar to the right it goes all the way out to column WTC rather than just the range of the data in the sheet.
Any ideas please or should I be using different code to insert this column in 2007?