How to insert a column

J

Jim Coyne

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
 
J

Jim Coyne

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

Thanks

Jim

Nigel said:
Jim,

Try this

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

Nigel







----== 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
Click to expand...
=---
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Smart inserting od colons 3
Two columns followed by single page-width column on same page 0
ASK Field Formatting 1
How to center adjust text above and image in a two column document. 1
List all tables, including document structure 0
Insert multiple objects at once ? 3
How to insert Certificated digital signature in Word for Mac 0
How to remove a bracket that is itallicised for an entire document 1

Top