Thread: PrintArea
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
[email protected] avpendse@gmail.com is offline
external usenet poster
 
Posts: 11
Default PrintArea

Thanks for the suggestion. However setting up the loop is not the
problem and hiding the row (19, 39, ... ) is not desirable.
I can set these print areas manually (Select 1st range then Set Print
Area , Select 2nd range then Add To Print Area ,.... and so on.) but
setting them throug VBA results in error.