I am trying to create a print range for a worksheet that has rows taken off from the top by a filter and added to the bottom by new entries. I keep having to change the range because I don't want the range so big it won't fit one page. (don't want empty rows printed) There must be some way to make the range dynamic but I cannot figure it out. Any suggestions would be appreciated