When I try to manually insert a column by highlighting it and then right-clicking and selecting insert, I get an error from Excel that "Excel can not insert a new column, because of non-blank cells off the worksheet". But when I manually setup a test workbook and insert headers and with data, clearly it is not blank, is allows me to insert a column, what is wrong with Excel ?
Or what am I doing worng ? I mean, this is annoying, I copy that sheet to a new workbook with the same data and try to insert the column and no error, it works ? and it is not protected, is this another Excel bug ? even if I select that column and delete all the data, I still can't insert a new column, I get that same annoying stupid error!
Excel 2003.
Looking for a VBA solution, basically trying to insert a column infront of AG which is not blank, headers start at A6, data at A7.
Thanks!
Or what am I doing worng ? I mean, this is annoying, I copy that sheet to a new workbook with the same data and try to insert the column and no error, it works ? and it is not protected, is this another Excel bug ? even if I select that column and delete all the data, I still can't insert a new column, I get that same annoying stupid error!
Excel 2003.
Looking for a VBA solution, basically trying to insert a column infront of AG which is not blank, headers start at A6, data at A7.
Thanks!
Last edited:
