N
nickel1976
I recently built a simple excel worksheet containing color changes and
some simple Excel Functions. This is a dynamically changing worksheet
in that I do need to occasionally add columns. When I do this, I
receive the error:
"To prevent possible loss of data, Microsoft Excel cannot shift non-
blank cells off the worksheet."
I searched the KB at Microsoft for this error and it appears to be
fault of the code design...? The workaround they offer at the website
is not acceptable.
Aside from having to write a macro to add new columns, is there
another way to add new columns containing the formatting I have in
place for all the others?
some simple Excel Functions. This is a dynamically changing worksheet
in that I do need to occasionally add columns. When I do this, I
receive the error:
"To prevent possible loss of data, Microsoft Excel cannot shift non-
blank cells off the worksheet."
I searched the KB at Microsoft for this error and it appears to be
fault of the code design...? The workaround they offer at the website
is not acceptable.
Aside from having to write a macro to add new columns, is there
another way to add new columns containing the formatting I have in
place for all the others?