We help IT Professionals succeed at work.

inser column T

142 Views
Last Modified: 2018-04-27
add an column blank between

this is how is

a12.PNG

this is how should be  

b12.PNGinsercolumn.xlsx
Comment
Watch Question

Roy CoxGroup Finance Manager
CERTIFIED EXPERT
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
Roy Cox

Thnks for the fast reponse

could be an button  to  add the columns

between the data
Roy CoxGroup Finance Manager
CERTIFIED EXPERT

Commented:
Well, just add a button and attach the code
insercolumn.xlsm
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
Roy Cox

need be for each column with data
Roy CoxGroup Finance Manager
CERTIFIED EXPERT

Commented:
What do you mean? You asked to insert Column T
Roy CoxGroup Finance Manager
CERTIFIED EXPERT

Commented:
Do you mean like this

Edit, corrected code
insercolumn.xlsm
Excel & VBA Expert
CERTIFIED EXPERT
Most Valuable Expert 2018
Awarded 2015
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION
NerdsOfTechTechnology Scientist
CERTIFIED EXPERT

Commented:
Fabrice LambertConsulting
CERTIFIED EXPERT
Distinguished Expert 2017
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION
Roy CoxGroup Finance Manager
CERTIFIED EXPERT

Commented:
What???
Fabrice LambertConsulting
CERTIFIED EXPERT
Distinguished Expert 2017

Commented:
@NerdsOfTech:
Alas, not everyone have the liberty to install 3rd party Tools or add-in. Nice link tho.

@Roy:
The global Columns collection implicitly refer to the ActiveWorkbook.ActiveWorksheet.Columns collection.
Wich guarantee do you have that ActiveWorkbook is the workbook holding the code ?
And wich guarantees do you have that ActiveWorksheet is the one one wich the code will be applied ?
Roy CoxGroup Finance Manager
CERTIFIED EXPERT

Commented:
The button is on the sheet, so to click it  the workbook must be active and the sheet must be active!
Subodh Tiwari (Neeraj)Excel & VBA Expert
CERTIFIED EXPERT
Most Valuable Expert 2018
Awarded 2015

Commented:
@Roy
You only missed a dot before columns, nothing else.
Don't take him seriously. Cool. :)
Fabrice LambertConsulting
CERTIFIED EXPERT
Distinguished Expert 2017

Commented:
@Roy:
This is a special use case (Ok, I admit it happen most of the time).
What if the function is called from somewhere else ?
Roy CoxGroup Finance Manager
CERTIFIED EXPERT

Commented:
Not my problem, Adriana asked for a button so my comments stand
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
Great Job!

;)

Best Experts !

 Roy Cox, Fabrice Lamber  , Subodh Tiwari (Neeraj)
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.