Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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
Posted to microsoft.public.excel.programming
|
|||
|
|||
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
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Insert Column after specific text title the new column and add for | Excel Discussion (Misc queries) | |||
VBA - insert column | New Users to Excel | |||
insert a blank column between each column in a data file | Excel Discussion (Misc queries) | |||
insert row / insert column command buttons | Excel Worksheet Functions | |||
Insert blank column every other column | Excel Discussion (Misc queries) |