add column in excel with VBA

exarkuun · November 18th, 2003, 05:10 PM

Hi,

I would like know how can i add column between others columns with VBA , exemple when someone click on a button.

thanks you

chrislepingwell · November 19th, 2003, 07:07 AM

Try something like this:

Code:

Sub Test()
Dim x as string

x = InputBox("Enter the column you need inserting, eg "a")

Workbooks("yourworkbook").worksheets("theworksheet").Columns(x).Insert

End Sub

Create your button, link its code to this sub, and you're away. Obviously, you will need to alter the names to suit application, and you will need some way of ensuring that the input is valid, but this is left as an exercise for the reader ;)

HTH

There are two secrets to success in this world:
1. Never tell everything you know

exarkuun · November 19th, 2003, 09:37 AM

Thanks you very much for the solution...