PDA

View Full Version : Header/Footer sticking to other ranges



AirplaneGuy
05-16-2020, 08:43 PM
I have macros to print certain ranges with certain print settings for each range. I have macros that add a header and footer on 2 ranges but not the third. However, once I print range 1 with the head/foot the settings "sticks" in the page setup and it begins printing on anything printed.

I'm positive it has something to do with the code I used for the macro, but I'm not sure what's causing it. Tried googling and searching here but oh man do you guys have a lot of stuff to dig through.

Paul_Hossler
05-17-2020, 07:15 AM
Welcome to the forum - please take a minute to read the FAQs at the link in my sig for our 'rules of the road'

Since we're not clairvoyant, we have no idea what the macros look like

Attach a small workbook with the ranges, macros, and expected / actual results so we understand the issue, and we'll be glad to look