View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
eshoobee1 eshoobee1 is offline
external usenet poster
 
Posts: 1
Default Add rows after hiding rows

I have a project that hides a row in the print area when a specified column
in that row equals zero. The number of hidden rows varies depending on user
input. I need a way to add the same number of blank rows at the end of the
list of printed rows so that the size of my print area does not change. An
suggestions?