vba- reset a sheet after printpreview

I have a userform (user does not see workbook that runs behind it) with commandbutton1 that advance-filters data from a worksheets("report") and does a print preview. when i print or close the preview window, how can i reset the worksheet("report") so the user can run a different report with different filters.

right now the form will not filter the second time because the first filter has empted the cells.

I think I resolved the problem by adding a line to the code

worksheet("report").showalldata