Updating distributed Excel applications

[Michael Malinsky]

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

 

[steveB]

Michael,

This inserts a column on "Sheet1" at column C (the original column C is
moved to column D)

Note that the insert is done without any select.

''''''''''''''''
Sub AddColumn()
Sheets("Sheet1").Range("C1").EntireColumn.Insert
End Sub
''''''''''''''''''
hth

 

[Chip Pearson]

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