Insert Column before a cell with Specific value

Hi everyone,
I want to create a command button that adds a column be4 a specified value every time is clicked.
I figured i might just search the row containing this value "Targets" and return is index, then use that
index as a basis to insert a new column.
I do find the target and its index , but it is not inserting my column.
I know there could be better code more guaranteed to work. some body can help.

Please Login or Register  to view this content.

All the Best

Hi, Tryagainandagain,

please check and change both SheetName and range if they do not fit your request:

Please Login or Register  to view this content.

Ciao,
Holger