View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ken Johnson Ken Johnson is offline
external usenet poster
 
Posts: 1,073
Default Inserting new column between the columns

Hi Ramana,
Sorry, I left out the bit about column width!
How about:

Public Sub Insert_Col()
Dim Sht As Worksheet
For Each Sht In Worksheets
With Sht.Range("F1")
..EntireColumn.Insert
..Offset(0, -1).ColumnWidth = 12
End With
Next
End Sub

This makes the column width = 12, change according to your needs.
Ken Johnson