Is there any logic with which to determine where to insert a column if the
specified data is in some other column? Do you have a list of texts to look
for or just one? HTH Otto
"Dow" wrote in message
...
I was unable to find the answer to this question. I know it is out
there but for some reason my search results are not providing what I
need lately.

I have a spreadsheet that varies in the number of columns (A through
Whatever). I want to use VBA to look at Row 2 and anywhere it says a
word or phrase (let's say "happy summer") I want to be able to insert
another column.

For example if D2 says "happy summer" I want to insert a column on F
and if, if B2 says "happy summer" I would want to insert a column on
C.

Any thoughts out there? You guys and gals are always very helpful.

Thank you,

Dow.