I am trying to copy over a workbook to a new workbook. I'm specifically not copying the sheets or workbook itself, since the original workbook is causing excel to crash and I'm copying the data over to hopefully leave behind whatever junk is the issue. However, there are hidden rows, and I want them to stay hidden. After messing around, I found code that worked, but I don't know why and it seems inefficient. So my question is: what is the best way to copy data and keep hidden rows hidden. Here is the inefficient code which requires copying and pasting the same data twice:
Please Login or Register  to view this content.
Bonus points if you can tell me why it was crashing in the first place. Symptom: When any cell around BX175:CX300 was referenced by any outside workbook, all of excel crashed. It could reference other cells, and by dragging relative references, you could get references to the "forbidden range", and once those references worked, you could edit them and re-reference like normal. However, if you chose a new cell and created a reference to that range, it would often crash.
Details:
Problem signature:
Problem Event Name: APPCRASH
Application Name: EXCEL.EXE
Application Version: 15.0.4675.1000
Application Timestamp: 54629b4c
Fault Module Name: EXCEL.EXE
Fault Module Version: 15.0.4675.1000
Fault Module Timestamp: 54629b4c
Exception Code: c0000005
Exception Offset: 006ff28d
OS Version: 6.1.7601.2.1.0.256.4
Locale ID: 1033

Additional information about the problem:
LCID: 1033
skulcid: 1033