Searching for a string and then perofming an action is present

[t16turbo]

I have a pivot table that I am copying and pasting into a new worksheet so I can insert some columns etc.

I need to 'search' row 4 for the existence of the word "Documentation". If I find it then insert an entire column tot he right of it.

If documentation does not exist then do nothing.

can anyone suggest some code that I could use for this?
thanks,
Matt

 

[PHV]

As a strarting point you may use the macrorecorder when you do it manually.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886