We have a a spreadsheet in excel 2003 format which has reached it's limit in terms of number of columns
We need to insert another column - is there a work around for this?
Also, if we delete columns we still cannot insert columns, getting the following error message:
To prevent possible loss of data excel cannot shift non-blank cells off the worksheet .......
We have checked for non-blank cells but cannot find any - unhiding fields still reveals no non-blank cells
We live in a world of interfaces like the one in the title picture. VBA also allows to use interfaces which offers a lot of possibilities. This article describes how to use interfaces in VBA and how to work around their bugs.