Offset print area

**stephdestrempes** · 06-26-2013, 03:24 PM

Hello,

I have set a print area with an offset formula (in name manager). However, each time I'm running a macro, the print area gets deleted. Does anyone can help me with that problem?

Thank you!

http://www.mrexcel.com/forum/excel-q...ml#post3506931

**zumbalj** · 06-27-2013, 01:52 PM

Is it just one macro, or multiple macros and any time you run any of them it's deleted? What does the macro you're running do? Can you post the code?

**stephdestrempes** · 06-27-2013, 02:06 PM

Originally Posted by zumbalj

Is it just one macro, or multiple macros and any time you run any of them it's deleted? What does the macro you're running do? Can you post the code?

The code is really big and it's actually five different macros. Also, I'm not a hundred percent sure it's because of the macros. I have the same offset formula in many different sheets and there's only one sheet where it always gets deleted (replaced by a normal array).

**zumbalj** · 06-28-2013, 06:28 AM

Are they five macros that are run separately, or all together? Can you run them individually to see if you can narrow it down to one macro causing (or not causing) the problem?