$$Excel-Macros$$ Selecting multiple sheets affects selections on those sheets

2016-10-31 Thread carl.malmquist
I am using ExportAsFixedFormat() to print multiple sheets to PDF. I use Sheets(Array("sheet1","sheet2",sheet3")).select to specify the sheets. For each sheet to print, I specify the range of cells to print. I've tried selecting the ranges on each sheet before grouping the sheets. I've tried

$$Excel-Macros$$ A macro pauses execution for no reason

2011-10-06 Thread carl.malmquist
A coworker sent me a workbook with a macro that runs fine on my laptop. On her laptop, the macro runs and at a random point within the macro, it pauses, as if that spot in the code has a break point. Hitting run restores the macro to running and it completes normally. Has anyone experienced with