Adding a Column

**WHS** · 02-08-2008, 01:37 PM

I am trying to add a column, but I am trying getting a message saying that Excel does not want to move non blank cells off the worksheet in case data is lost. It suggests I use Control End to get to the end of the data then clear all the blank cells, click on A1 and then Save.
I have tried all this but it doesn'tb help. Also I don't understand any of this - I don't even know what a worksheet is and I don't understand why adding a column is pushing cells off the edge of it. As far as I am aware, I have not set a size to the spreadsheet I am building. Help!!
WHS

**VBA Noob** · 02-08-2008, 01:43 PM

Your workbook contains worksheets. There are usually named Sheet1, Sheet2 , Sheet 3. If you press F5 in the sheet you are trying to add the column then press special > last used cell. then delete and info you don't require

e.g . If you think data finish in Col L and last used has data in Col Z select M to Z and right click > delete

VBA Noob

Adding a Column

LinkBack

Thread Tools

Rate This Thread

Display

Adding a Column

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions