Code to insert a row above a cell containing specific sequence of text

Hello

I was wondering if someone might be able to assist me with using VB to insert a new row above a cell containing some specific text.

For example:

- My data is in column b
-I want to scan all of column b, and if there is a cell that contains "xxx" at the start of a text string then I want a blank row inserted above it. If column b does NOT contain that text....do nothing.

(NB this is a modified example of a previous question. The difference for me is that the text "xxx" is at the start of a string so I need a response that will deal with this.)

Thanks very much in advance,

Adam

Hi,

Try this:

Please Login or Register  to view this content.

Dom