How to insert a column
 

Is it possible to insert an entire column between columns A and B?

I've been searching the Microsoft documentation but have not found anything
yet.

thanks

Jim

How to insert a column
 

Jim,

Try this

Columns("B:B").Select
Selection.Insert Shift:=xlToRight

Nigel


"Jim Coyne" wrote in message
...
Is it possible to insert an entire column between columns A and B?

I've been searching the Microsoft documentation but have not found
anything
yet.

thanks

Jim






----== Posted via Newsfeed.Com - Unlimited-Uncensored-Secure Usenet News==----
http://www.newsfeed.com The #1 Newsgroup Service in the World! 100,000 Newsgroups
---= 19 East/West-Coast Specialized Servers - Total Privacy via Encryption =---

How to insert a column
 

Yes, that worked. It's taking some time getting use to Excel VBA even with
years of VB experience.

Thanks

Jim

"Nigel" wrote in message
...
Jim,

Try this

Columns("B:B").Select
Selection.Insert Shift:=xlToRight

Nigel


"Jim Coyne" wrote in message
...
Is it possible to insert an entire column between columns A and B?

I've been searching the Microsoft documentation but have not found
anything
yet.

thanks

Jim






----== Posted via Newsfeed.Com - Unlimited-Uncensored-Secure Usenet
News==----
http://www.newsfeed.com The #1 Newsgroup Service in the World! 100,000
Newsgroups
---= 19 East/West-Coast Specialized Servers - Total Privacy via Encryption
=---