Thread: Setting Print Area
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mike[_122_] Mike[_122_] is offline
external usenet poster
  
Posts: 2
Default Setting Print Area
Hi,
Is it possible to set/reset the print area according to a cell value?

e.g.:-
if A1 = 1 then set print area to B1:B10
if A1 = 2 then set print area to C1:C10
etc.
TIA
Mike


Reply With QuoteReply With Quote