Don,

I posted a similar solution to this Discussion group a few days ago. It can
be found @:

http://Galimi.com/Examples/MS.xls

http://HelpExcel.com

"Don" wrote:

Would someone show me the proper way to code a procedure to add a row every
time the word "Subtotal" is found in column B of a spreadsheet. Secondly,
how do I attach this procedure to a button? I'd like the routine to run once
and find every instance of this word and then add the row instead of me
having to do this for each instance of the word. A simple thing, I'm sure,
but I don't know how. Thanks...
--
Don Rountree