View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
timwell timwell is offline
external usenet poster
 
Posts: 5
Default Help inserting row after text

Hello,
I have a spreadsheet that I am trying to divide into sections with a
macro.
In column A, starting in cell A9 and going down, each section is
divided by 4 dashes("----").
I would like the macro to find the "----" and then move down 2 rows and
insert a row.
This would divide the section and its subtotals from the next section
of data.
The data can contain up to 2000 rows.
Thanks so much for any help.
Timwell