View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jim Cone[_2_] Jim Cone[_2_] is offline
external usenet poster
 
Posts: 1,549
Default Printing non-contiguous rows at the top

Try using Rows(1:6) and then hide Rows(3:4)
If that messes up the appearance of page one then print page 1 separately.
--
Jim Cone
Portland, Oregon USA


"Rich Burt" .(donotspam)
wrote in message
Using the 'rows to repeat at top' field of page setup, is there a way to
print non-connected rows (i.e. rows 1, 2, 5, & 6)? The formula only allows
for $1:$x and all rows inclusive.
--
Rich Burt
Fresno, CA