Hide unwanted rows and and Columns
Posted by Abhijeet on July 30, 2001 5:51 AM
I want to hide unwanted empty Rows and columns thru VBA. The following code is taking considerable time. If i do it manually from Excel it doesn't take much time. How??
The code is:
Application.ScreenUpdating = False
Selection.EntireColumn.Hidden = True
Selection.EntireRow.Hidden = True
Application.ScreenUpdating = True