How can I make all but a selected range hidden on a workshee

[jgoulart]

Is there a way to make all but lets say range("A1:L33") hidden on worksheet?

John

 

[Juan Pablo González]

You could hide rows 34:65536 and columns M:IV too.

 

[Mudface]

The following should work OK if you want to do it in VBA: -

Dim ColsToHide As Range
Dim RowsToHide As Range

Application.ScreenUpdating = False

Set ColsToHide = Range("M:IV")
Set RowsToHide = Range("A34:A65536")

ColsToHide.EntireColumn.Hidden = True
RowsToHide.EntireRow.Hidden = True

Application.ScreenUpdating = True