| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro to Inserting Columns and then add column to horizontal total | Excel Discussion (Misc queries) | |||
| Inserting columns | Excel Discussion (Misc queries) | |||
| Inserting new columns past the last column | Excel Discussion (Misc queries) | |||
| inserting new columns | Excel Discussion (Misc queries) | |||
| Inserting columns into a row | Excel Discussion (Misc queries) | |||
Threaded Mode
