Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Macro to copy cells to rows below | Excel Discussion (Misc queries) | |||
Macro to hide rows with empty cells | Excel Worksheet Functions | |||
macro - hiding rows given a cells content | Excel Programming | |||
Macro to copy cells one row up then move down 4 rows & repeat | Excel Programming | |||
Macro to delete rows with text cells | Excel Programming |