About
Pricing
Community
Teams
Start Free Trial
Log in
Andreas Hermle
asked on
4/13/2017
add a column label to a list object using VBA
Dear Experts:
I got a list object on the active worksheet named 'MyTable'.
I would like to enter the term 'PageBreak' as
Column Label
to the right of this list object (MyTable') using VBA
Example:
Before:
ItemNo Description Country Address
After:
ItemNo Description Country Address PageBreak (Column Label 'PageBreak' to be added via VBA)
In other circumstances the list object 'MyTable' may have 10 columns not just 4 columns before the macro is run.
Help is much appreciated. Thank you very much in advance.
Regards, Andreas
VBA
Microsoft Excel
Microsoft Office
2
1
Last Comment
Andreas Hermle
8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Rgonzo1971
4/13/2017
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
Andreas Hermle
4/13/2017
ASKER
Hi Rgonzo,
great, this did the trick, thank you very much for your great help.
Regards, Andreas
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck
great, this did the trick, thank you very much for your great help.
Regards, Andreas