Is the Child different from the Family?

[prabhafriend]

Column is the property of Range right? Then why doesn’t the Activesheet.range.column(1).insert work?

[GTO]

Column is a range property, but it is a read-only that returns the column number of the leftmost column in the referenced range. For instance:


MsgBox Range("D7:E10,J23:P44").Column

...returns 4, as Col D is the leftmost col in the above.

Mark

[mbarron]

To do what you want, omit the Range and pluralize the Column
ActiveSheet.Columns(1).Insert