insert row by function

May 28, 2012 at 06:17:26
Specs: Windows 7
i need to know the function in excel2007 that help me to insert a blank row before every row contain a specific word like if ihave row`7` contain word `test` then i want the function that insert a row above row 7 and every row contain the same word and make thos blank rows with a specific color

See More: insert row by function

Report •

May 28, 2012 at 16:48:18
There is no function to insert rows or color a row.

You would need to use VBA.

Tthe code would have to find each occurrence of your keyword and then insert a row and color it.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •
Related Solutions

Ask Question