View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Mark Lincoln Mark Lincoln is offline
external usenet poster
 
Posts: 227
Default Why is inserting rows throwing off my hidden rows

If you insert a number of cells and shift down, you are only moving the
cells in those columns. This shifts cells that were in the hidden rows
down one row while leaving the other hidden cells unchanged.

If you insert an entire row, the hidden rows will move and their
contents will remain hidden. You could do something like

Worksheets("Sheet1").Rows(12).Insert

to insert a row before row 12, then copy and paste your hidden
information into the new row 12.