[Developer]

Hi, I am using Excel 2003 at office, are there any experts to teach me how to use Marco or VBA to automatically insert lines before and after designated word in each cell under the same column. Example. Under the column A, there are Cell A1...

Hi,

I am using Excel 2003 at office, are there any experts to teach me how to use Marco or VBA to automatically insert lines before and after designated word in each cell under the same column.

Example.
Under the column A, there are Cell A1 to A100, each cell has the same word of “Interval” but it exists in different description. (Whatever they show, I want to use “Interval” and “Interval:”as my keyword to make formula or Macro)

A1: (Original)
Change engine oil.Interval: 5000 KM.
A2: (Original)
Lubricate axle joint.Interval: 3000 Hours.




I want to: (note: * = line break)

:up:-Insert 2 lines (line break) before “Interval” and
:up:-Insert 1 line after “Interval:” and
:up:-automatically search the last position of the content in A1 to A100, and insert 2 lines after it

A1:
=======================
Change engine oil.*
*
Interval:*
5000 KM.*
*
=======================
A2:
=======================
Lubricate axle joint.*
*
Interval:*
3000 Hours.*
*
=======================


Thank you very much for help,

Happy New Year !

Scott

In Canada