View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Chris Salcedo Chris  Salcedo is offline
external usenet poster
 
Posts: 25
Default no page break in named range

I have a sheet that has about 110 named ranges in it. They are about
15 rows tall (they can vary). What I would like to do is when I go to
print (11x17) a named range will not get cut off (i.e. part on one
page and part on the next page) Like a keep together. A macro that
would insert the page breaks on the sheet would work great.