Activesheet.Pagesetup put slow my macro!

[AlexHarley666]

Hello!!!

My problem is the next: I have a macro to make 'X' report. In macro's end, I put the next line:

ActiveSheet.PrintArea.PageSetup = "A6:" & VarCell

But, if I try again process the macro, this is more slowly than first time (t * 3).

What's the way to nullify printarea. I attempt with:

ActiveSheet.PrintArea.PageSetup = ""

but not it works...

Please Help...!!!

 

[SkipVought]

Hi,

    ActiveSheet.PageSetup.PrintArea = ""

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884

Skip,

http://www.TheOfficeExperts.com

 

[AlexHarley666]

Hi...

Yes, the line is 'ActiveSheet.PageSetup.PrintArea = ""' (I did put incorrect line, sorry ), but, still I try again to execute macro, and this is too slow.

 

[SkipVought]

Do you have any other page setup code? page setup code processes VERRRRRRRY SLOOOOOOOOOOW! ;-)

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884

Skip,

http://www.TheOfficeExperts.com

 

[xlbo]

Because every single line in the pagesetup is a call to the printer

Rgds, Geoff
[blue]Si hoc signum legere potes, operis boni in rebus Latinus alacribus et fructuosis potiri potes![/blue]
Want the [red]best[/red] answers to your questions ? faq222-2244

 

[AlexHarley666]

@SkipVought: thanks... finally, I did decided to delete PageSetup line and to process the line in another sheet.

Really, Pagesetup put my macro very slow!!!

Well, thank you very much for your help B)