Hi all, I need some help writing a code to insert two rows above any row that has the text string "BIG" in column A. I would like for the code to run only in my selection area rather than throughout the entire sheet.
For example;
Column A
IT1
BY
NYC
BIG
TC
BIG
Should look like:
Column A
IT1
BY
NYC
BIG
TC
BIG
Thanks in advance for your help!
For example;
Column A
IT1
BY
NYC
BIG
TC
BIG
Should look like:
Column A
IT1
BY
NYC
BIG
TC
BIG
Thanks in advance for your help!