i have a spreadsheet with a VB Script that hides rows based on a specific value. The sheet is 190 rows, but at any point in time there are only 75-100 rows that need to print.
I've set the print area to be B1:I188 which is the desired area of the spreadsheet.
Problem is that there seems to be a page break entered after row 110 (approx) even if there are only 50 or so rows visible.
I've cleared all page breaks in the doc.
I need either a VB Script help or Macro that will completely ignore hidden rows and perceived page breaks.
I've searched the forum and can't find anything relevant to this problem (though have seen similar problems). I'm a "script kiddie" so I can generally interpret and modify scripts, but am not a programmer myself.
Any help will be paid in beer if you are local
I've set the print area to be B1:I188 which is the desired area of the spreadsheet.
Problem is that there seems to be a page break entered after row 110 (approx) even if there are only 50 or so rows visible.
I've cleared all page breaks in the doc.
I need either a VB Script help or Macro that will completely ignore hidden rows and perceived page breaks.
I've searched the forum and can't find anything relevant to this problem (though have seen similar problems). I'm a "script kiddie" so I can generally interpret and modify scripts, but am not a programmer myself.
Any help will be paid in beer if you are local
