Cacher is the code snippet organizer for pro developers

hide:
Rows().EntireRow.Hidden = 0
Columns().EntireColumn.Hidden = 0

.Interior.ColorIndex

Application.ScreenUpdating = True