| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Adding Columns in Excel 2007 (2003 Compatibility Mode)
both Please advise,
I am trying to add columns as per the following code: Columns("B:B").Select Selection.Insert Shift:=xlToRight, CopyOrigin:=xlFormatFromLeftOrAbove When i check the worksheet, columns A and B have been selected, If I run the following code: Columns("C:C").Select Selection.Insert Shift:=xlToRight, CopyOrigin:=xlFormatFromLeftOrAbove only Column C is selected. Can anyone help? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Adding Columns in Excel 2007 (2003 Compatibility Mode)
I didn't start xl2007, but different versions of excel treat merged cells
differently. Do you have any cells in A:B that are merged? AndyJ wrote: both Please advise, I am trying to add columns as per the following code: Columns("B:B").Select Selection.Insert Shift:=xlToRight, CopyOrigin:=xlFormatFromLeftOrAbove When i check the worksheet, columns A and B have been selected, If I run the following code: Columns("C:C").Select Selection.Insert Shift:=xlToRight, CopyOrigin:=xlFormatFromLeftOrAbove only Column C is selected. Can anyone help? -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Adding Columns in Excel 2007 (2003 Compatibility Mode)
Cheers Dave,
I didnt consider that!. I have been writing in VB.NET and not VBA for the last couple of years and have forgotten some simple checks. Thanks for your help. "Dave Peterson" wrote: I didn't start xl2007, but different versions of excel treat merged cells differently. Do you have any cells in A:B that are merged? AndyJ wrote: both Please advise, I am trying to add columns as per the following code: Columns("B:B").Select Selection.Insert Shift:=xlToRight, CopyOrigin:=xlFormatFromLeftOrAbove When i check the worksheet, columns A and B have been selected, If I run the following code: Columns("C:C").Select Selection.Insert Shift:=xlToRight, CopyOrigin:=xlFormatFromLeftOrAbove only Column C is selected. Can anyone help? -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I turn off compatibility mode in Excel 2007? | Excel Discussion (Misc queries) | |||
| Excel 2007 Compatibility Mode | New Users to Excel | |||
| Excel 2007 Compatibility Mode Not Responding | Excel Discussion (Misc queries) | |||
| Compatibility Mode to Excel 2007 | Excel Worksheet Functions | |||
| Excel 2007 always opens in Compatibility Mode | Excel Discussion (Misc queries) | |||
Linear Mode
