Print area and borders macro based on cells contents

Hi JBeaucaire

Thanks it looks a lot tidier, unfortunatly when i try to run it an error message comes up "Object doesn't support this property or method".
It's not like i use excell everyday but it's the first time i see this error.

Can you help


Many thanks
Jsantos

Hi JBeaucaire
Made the change as you sgested and it now runs for about 4 seconds to then give me error "400"
At first it was giving me far more pages than i expected, but manage to find out that the sheets i was using initially had borders that would make the print area go to the 50 plus pages. I corrected this but can't see the reason for this error code come up.
As far as i can see everything i wanted gets done.

Many thanks for your pacience and help

Jsantos

Hi JBeaucaire
The reason for the error was because one of the sheets was protected.
One last question:
Would it be possible to stop the above macro to apply to one sheet in the workbook? In this case the sheet would always have the same name ("Header")?


Many thanks
Jsantos

Hi JBeaucaire

Your change will make the macro run just for that particular sheet, what i want is to have the macro applying my instructions to all the sheets but the "Header" sheet.
My workaround is as follows, just tought there would be something that would stop the macro running on that sheet.
It takes quite a while to run this macro thats why i was thinking about a way to remove this sheet from it.

Regards
Joaquim

Please Login or Register  to view this content.

Many Many thanks
This ends my long list of requests.

Untill the next time

Kind regards
Jsantos