Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Why is inserting rows throwing off my hidden rows
I have a macro that is using the following code to copy a template row
that is hidden and then it inserts that row below it. The problem is that all of the hidden rows that are below where I'm inserting are not changing to account for the added row. For example. rows 15, 20 and 25 have templates in them and are hidden then I will do the following copy template from row 10 insert template at row 12 Even though all of the data has shifted down 1 row, rows 15, 20 and 25 are still hidden and all of the data that was in those hidden rows are now showing in rows 16, 21 and 26. Sheets("Inline").Range("Template").Copy Sheets("Inline").Range("ResDetEnd").Insert Shift:=xlDown Application.CutCopyMode = False Am I forgetting something? Any help would be appreciated. Thanks, James |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro code to hide rows and not calculate hidden rows | Excel Discussion (Misc queries) | |||
Count number of rows, where non relevant rows are hidden | Excel Discussion (Misc queries) | |||
Excel 2003 -Rows hidden. Scrolling unhides rows ! How do I stop th | Excel Discussion (Misc queries) | |||
Inserting multiple rows in excel with data in consecutive rows | Excel Programming | |||
deleting hidden rows so i can print only the rows showing?????? | Excel Worksheet Functions |