Insert row if cell contains caracters
 

Hi I found a couple of macros to insert rows if one cell contents is
different form another or if a cell value = a value. My cell contains the
characters €œTotal€� and other characters as well, I need to insert a row below
every cell in A that contains the characters €œTotal€�,
Thanks for a lovely space.

Insert row if cell contains caracters
 

Using what you already have, try the following:

If currentselection.Value Like "*Total*" Then

This will find "Total" if it has characters before or after.
--
-SA


"Esrei" wrote:

Hi I found a couple of macros to insert rows if one cell contents is
different form another or if a cell value = a value. My cell contains the
characters €œTotal€� and other characters as well, I need to insert a row below
every cell in A that contains the characters €œTotal€�,
Thanks for a lovely space.