Mike,

You would be much better off adding the newly required column to
the right of the existing data.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"Michael Malinsky" wrote in message
...
I have a VBA application that I've distributed to a couple of
clients. Now
some changes need to be made to the worksheets to conform to
various
regulatory requirements. These changes would need to be made
to what could
be called "data" worksheets from which various "form"
worksheets pull
information based on lookup (and other) functions.

Say, for example, I need to add a column to the middle of one
of the data
sheets. Is it possible to do that programatically without
destroying the
data so the client does not have to recreate the data?

TIA
Mike

--
Michael J. Malinsky
Pittsburgh, PA

"I am a bear of very little brain, and long
words bother me." -- AA Milne, Winne the Pooh