Hi
If rows and columns have been hidden try

Sub tester()
ActiveSheet.Columns.Hidden = False
ActiveSheet.Rows.Hidden = False
End Sub

regrads
Paul

On May 3, 5:21 pm, clara wrote:
Hi all,

The blank ranges on a worksheet should be hidden out before the worksheet is
printed. It is easy to do it, but after printing, the worksheet shoul
restore to its original state before printed. Is there an easy way to do it
in Excel?

Clara

--
thank you so much for your help