Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to add a new column with the previous column formula?
Hi everybody;
How can I write a macro to add a new column to the right of the last column of my sheet , in a way that it also copy all the formulas from the previous column? regards, Sean |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to add a new column with the previous column formula?
Sean,
Here is some code Dim cLastCol As Long cLastCol = Cells(1, Columns.Count).End(xlToLeft).Column Cells(1, cLastCol).EntireColumn.Copy Destination:=Cells(1, cLastCol + 1) -- HTH RP (remove nothere from the email address if mailing direct) "arshia22" wrote in message ups.com... Hi everybody; How can I write a macro to add a new column to the right of the last column of my sheet , in a way that it also copy all the formulas from the previous column? regards, Sean |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Based on data in previous column - sum of values in next column | Excel Worksheet Functions | |||
Shortcut to select column with data in previous column | Excel Discussion (Misc queries) | |||
vlookup value from previous column | Excel Discussion (Misc queries) | |||
How to add previous sums in a column to current sums in a column? | Excel Worksheet Functions | |||
Previous Column | Excel Programming |