Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default 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


  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 16
Default 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 =---
  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default 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

=---


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Insert Column after specific text title the new column and add for David Excel Discussion (Misc queries) 5 October 2nd 09 04:03 PM
VBA - insert column Tree*Rat New Users to Excel 11 October 22nd 08 08:22 PM
insert a blank column between each column in a data file Holly Excel Discussion (Misc queries) 1 October 31st 07 07:04 PM
insert row / insert column command buttons fairgreen Excel Worksheet Functions 1 October 29th 07 02:41 PM
Insert blank column every other column saman110 via OfficeKB.com Excel Discussion (Misc queries) 2 August 29th 07 09:06 PM


All times are GMT +1. The time now is 08:00 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"