Hi everybody!
I have found a copy/paste limit on the print area. Using the ActiveSheet.PageSetup.PrintArea function, I can only set up to 18 specific ranges before it won't allow me to set anymore. When I try to copy/paste it manualy in the page setup options, it won't allow me either. I am able to manualy type the amount in, but I can't copy, paste it.
Excel: Variable too large for PrintArea, vba macro, part8::
Subject: Variable too large for PrintArea Question Bob, I am trying to use a VBA macro to set Excel's Print Range that varies each time the macro is run.
http://en.allexperts.com/q/Excel-1059/Variable-large-PrintArea.htmHOME |
Example: $A$1:$D$17,$I$1:$L$17,$Y$18:$AB$30,$AK$18:$AN$30,$ BM$18:$BP$30,$M$31:$P$47,$AW$31:$AZ$47,$BI$48:$BL$ 64,$AG$65:$AJ$81,$AW$65:$AZ$81,$A$82:$D$98,$U$82:$ X$98,$AC$99:$AF$111,$AS$99:$AV$111,$BA$99:$BD$111, $AS$112:$AV$128,$BI$112:$BL$128,$I$129:$L$139,$U$1 29:$X$139
Excel VBA Models Set 1 download - Excel VBA Models Open Source ::
2008 Printable Calendar 1.0 download Freeware Excel VBA Models Set 1. XL- VBA1.0 by Excel Business Solutions Int'l Corp.
http://www.bestvistadownloads.com/software/t-free-excel-vba-models-set-1-download-wefsnnwk.htmlHOME |
PrintArea Property [Excel 2003 VBA Language Reference]::
PrintArea Property [Excel 2003 VBA Language Reference] Set this property to False or to the empty string ("") to set the print area to the entire sheet.
http://msdn.microsoft.com/en-us/library/aa176107.aspxHOME |
The is is exactly one range too long.
Does anybody have any suggestions?
Thanks for your time!
Hi, if you try and do something manually you will often find code has the same constraints. The only thing I can think of to resolve this is to copy the ranges to a new sheet then print the new sheet. You can of course automate this with code to create a sheet, copy ranges, print then delete the sheet. Try using the macro recorder then post the code if you have trouble.
hth
 Traditional University or MLM University? You Choose
 15 Questions to Ask Your Software Vendor
|
Set Print Area - VBA