Hello -
I am using the following script to set print areas and run a macro fo
many worksheets at once. Works great, except that I really need t
exclude about 5 worksheets from a 100 sheet workbook when using th
function.
Any suggestions would be appreciated!

Sub SetRange()
For Each UsrSht In ActiveWorkbook.Worksheets
UsrSht.PageSetup.PrintArea = "$A$1:$F$30"
Next UsrSht
End Sub

thanks,
Annabe

--
annabe
-----------------------------------------------------------------------
annabel's Profile: http://www.excelforum.com/member.php...fo&userid=2652
View this thread: http://www.excelforum.com/showthread.php?threadid=44141