Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Add a new column to a worksheet
Hello all,
I'm trying to make an application that needs to create new columns as the user inputs the data. The problem appears when the user wants to create a new column between two previously created. The data should move to the right (as happens when you push "create a complete column" in the popup menu of the grid. I don't know if there is a way to add a new column this way without having to move the data by hand (and so, having to change the formulas by hand). Could you help me, please? Thank you all :) |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Add a new column to a worksheet
Columns(3).Insert
should insert a new column 3 and the old column 3 is shifted to the right. -- Regards, Tom Ogilvy "Yoda" wrote: Hello all, I'm trying to make an application that needs to create new columns as the user inputs the data. The problem appears when the user wants to create a new column between two previously created. The data should move to the right (as happens when you push "create a complete column" in the popup menu of the grid. I don't know if there is a way to add a new column this way without having to move the data by hand (and so, having to change the formulas by hand). Could you help me, please? Thank you all :) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Looking up a variable in one worksheet and copying information from another column to another worksheet?? | Excel Discussion (Misc queries) | |||
Populating a column in a worksheet from another worksheet based on a common field | Excel Programming | |||
Transfer entities from rows/column of one worksheet to another worksheet | Excel Programming | |||
Fill a column in a worksheet from a formula worksheet based on the date | Excel Programming | |||
Upload multiple text files into 1 excel worksheet + put the filename as the first column in the worksheet | Excel Worksheet Functions |