Macros
 

I'm very new at macros. In creating the macro, I want to go to the cell that
has the words "END OF REPORT" and then add rows. I got itto add the rows,
but I don't know how to get it to always go to "END OF REPORT", which will be
on different line every time it's modified. (But always in Column A).
Thanks for any help you can provide.

KK

Macros
 

Have a look in vba help for FIND

Sub findtext()
With Cells(Columns(1).Find("xx").Row, 1)
..Select
'.Rows.Insert
'or
..Offset(1).Rows.Insert
End With
End Sub

--
Don Guillett
SalesAid Software

"kleivakat" wrote in message
...
I'm very new at macros. In creating the macro, I want to go to the cell
that
has the words "END OF REPORT" and then add rows. I got itto add the rows,
but I don't know how to get it to always go to "END OF REPORT", which will
be
on different line every time it's modified. (But always in Column A).
Thanks for any help you can provide.

KK