ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   excel.interop insert a column in between existing columns (https://www.excelbanter.com/excel-programming/425120-excel-interop-insert-column-between-existing-columns.html)

cupboy

excel.interop insert a column in between existing columns
 
Any example of how to do this? I tried this, but it does nothing....

rangeXX = ws.get_Range("Q1", "Q1");
rangeXX.Columns.EntireColumn.Insert(Excel.XlInsert ShiftDirection.xlShiftToRight,
Type.Missing);

JLGWhiz

excel.interop insert a column in between existing columns
 
Sub dk()
Columns("D").Insert
End Sub

"cupboy" wrote:

Any example of how to do this? I tried this, but it does nothing....

rangeXX = ws.get_Range("Q1", "Q1");
rangeXX.Columns.EntireColumn.Insert(Excel.XlInsert ShiftDirection.xlShiftToRight,
Type.Missing);



All times are GMT +1. The time now is 12:17 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com