How to insert blank row above a cell containing specific text

**Excelfail** · 03-09-2014, 06:56 PM

Hi everyone

Can someone assist me with using VB to insert a new row above a cell containing the word "Asset"?

I've attached a copy of my spreadsheet if that helps!

Thanks
Emma

**alansidman** · 03-09-2014, 07:04 PM

Emma

Try this:

Please Login or Register  to view this content.

**Excelfail** · 03-09-2014, 07:49 PM

Hi - sorry, thought I'd replied but obviously mucked up somewhere! Solution is perfect, thanks so much for your help

**excelactuary** · 05-23-2019, 08:08 AM

One question: This code inserts a row with formatting. If you want a completely blank row without formatting, how would you change the code?

**alansidman** · 05-23-2019, 09:19 AM

@excelactuary

Administrative Note:

Welcome to the forum.

We are happy to help, however whilst you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original. Please start a new thread - See Forum rule #4

If you are not familiar with how to start a new thread see the FAQ: How to start a new thread