I have code that filters a sheet of data based on a criteria that changes daily. On a form I have a button that prints the results of the filter. I presently am just setting a print area big enough to capture the results, but I would like the print area to be selected based on the results of the filter, or should I say the size of the remaining range.
I need code to set the print area of the range remaining after the filter is applied. I know it's a first row last row selection. Please help.
Roughleg
Bookmarks