$$Excel-Macros$$ Macro to hide rows, print, unhide rows runs very slow - how to speed up?

2012-03-19 Thread Mel
I have a macro that will hide unused rows in a spreadsheet, print the active sheet, then unhide the rows. Spreadsheet is from cell A1 to P175. Base info is recorded in various cells on rows 1 to 4. Cells 5 to 16 display output. The main Data input starts in cell A18 to G 167. A18 is a

RE: $$Excel-Macros$$ Macro to hide rows, print, unhide rows runs very slow - how to speed up?

2012-03-19 Thread Asa Rossoff
, print, unhide rows runs very slow - how to speed up? I have a macro that will hide unused rows in a spreadsheet, print the active sheet, then unhide the rows. Spreadsheet is from cell A1 to P175. Base info is recorded in various cells on rows 1 to 4. Cells 5 to 16 display output. The main