insert column vba

Hello, I created a workbook that automatically add a certain number of columns. I need these new columns to copy the formulas over from the original column. For example, I have a main column that is present in every sheet (the formulas are different in every sheet). This column has formulas...

Good Day all, long time / first time I've been on Google the previous day looking at compiling a series of macros to do the following (I will break up in to unique tasks): #1 : scroll through a workbook with 70+ tabs and find a uniquely named tab (that will change spreadsheet to spreadsheet)...

A bit of a novice here. I usually try to find my answers first before posting, although I kinda found an answer on a thread here, when asking for help I was told to start a new thread. So... I have a sheet with 5 columns (C-G). I need to insert 5 columns with the same formatting and formulas...

I am working on an inventory project and have 2 problems that i cannot find a solution for. 1. The first is i need to select the first empty cell in the first row and fill it with the current date. I have the code for the date working great and the code works fine the first time, but after...

Hi All, I have a table that needs to expand to another column, and I know that cell "b3" is a part of that table. I know that: Range("B3").CurrentRegion.Select will select the entire table, but how should I go about expanding it one more column? Thanks a ton, Bill

Hi, I need to insert a column as the last column in an excel using VBA. Could you please help me to do this? I need to insert a column as "Last Column" in the excel. <tbody> Sl.No(A) Name(B) Last Column(C) </tbody> Best Regards, bhandarx

Hello - I am trying to create a macro which inserts two columns prior to the final two columns 'Total' in my worksheet. When I recorded the macro, the VBA was obviously written to always insert columns at 'BD' and 'BE': Sheets("VDN").Select Columns("BD:BE").Select Selection.Insert...

Hello everyone , i am very new to this . i Was wondering if anyone can help me i have a two step problem The first part of it is that i would like to be insert a new Row between each row on my Excel sheet that has data so if i have had Kilometres Time 1 10 3...

Hi VBA Gurus, First of all, great website! It really helps newbie Excel-VBA users like me. I am currently using MS Excel 2007. Is there a way in VBA to automatically insert missing columns based on a defined series or range of values? For example, we have a report that displays columns of...

Hi, I have got an excel spreadsheet that I have some rows protected in (utilising a macro). Because of the protected rows I can no longer insert new columns as the option is greyed out (because I have protected it against selecting some of the rows) when I right click a column header. Is there...

<TABLE style="WIDTH: 158pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=211><COLGROUP><COL style="WIDTH: 158pt; mso-width-source: userset; mso-width-alt: 7716" width=211><TBODY><TR style="HEIGHT: 22.5pt; mso-height-source: userset" height=30><TD style="BORDER-BOTTOM...