Posts by dave1701

Re: Find a text string in a column and perform action if true

To be honest, my VB isn't very good. This looks great but how do I put this in as Excel file?

I have a column that contains a text string (ex: NOTE 5). I want to search this column to see if there is a string other than "NOTE 5" (ex: NOTE 6). If there is I print notes 1-6, if not I print notes 1-5. IF "NOTE 6" is in column o (o7:o100) THAN print notes 1-6 ELSE print notes 1-5.