View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
jmcnelis jmcnelis is offline
external usenet poster
 
Posts: 2
Default Macro to add rows between cells - new at VBA

I have a spreadsheet at work that contains all the schedules for our
SAP scheduling program. This spreadsheet is used for recovery
procedurs for the specific jobs. The problem with the spreadsheet is
that each schedule has END as it's last line, and the next line is the
name of the next schedule. I would like to add two blank rows between
END and the next schedule name. I have a macro that does a find for
END, and then inserts two rows, but the rows go above the END. As I am
new to VBA (never needed to use it until now, so now I'm trying to self
teach), I'm not sure how to get the rows to go under the END cell.
Also, I'm not sure how to have it work for each END in the spreadsheet,
not just one at a time. Any help would be greatly appreciated!

Joey