Ensure/force that a header (cell) is selected row of headers (dynamic range)

[Eric Carolus]

Hallo gurus

I can now insert a new column with its own header into a row of headers (thanks to help on this forum).
The new column (for which I will add a header) will be inserted to the left of an
existing column with header.

My problem how do I ensure that a header cell is selected and not any other cell
on the worksheet"? (Sheet1)

I can use all help I can get. https://www.dropbox.com/s/qy1gduz7bijiyq3/Insert a column.xlsm?dl=0

Thanks

Eric

 

[Fluff]

Do you want to add the new column added before a specific header?

 

[Eric Carolus]

Hi Fluff

No. The column can be inserted anywhere WITHIN the header range.
Preferably not before B1 as I copy the formats from this column to
subsequent columns.

Thank you.

Eric

 

[Fluff]

In that case how about

Sub EricCarolus()
   Sheets("sheet1").Range("C:C").EntireColumn.Insert
End Sub

 

[Eric Carolus]

Hi Fluff

It certainly works. But how do I ensure that
a selection is made from the header row ONLY?

Thank you.

Eric

 

[Fluff]

I'm afraid I don't understand what your asking