or

Sub uh()
Rows.Hidden = False
Columns.Hidden = False
End Sub


--
Don Guillett
SalesAid Software

"Roger Govier" wrote in message
...
Hi Dileep

Cells.Select
Selection.EntireRow.Hidden = False
Selection.EntireColumn.Hidden = False

--
Regards

Roger Govier


"Dileep Chandran" wrote in message
oups.com...
Ok, Thats good. Before copying this specified range is it possible to
unhide all rows and columns in Sheet1?

-Dileep