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

jgoulart · Mar 10th, 2002, 11:27 AM

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

John

Juan Pablo González · Mar 10th, 2002, 11:33 AM

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

Mudface · Mar 10th, 2002, 12:22 PM

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

Mar 10th, 2002, 11:33 AM	#2
Juan Pablo González MrExcel MVP Join Date: Feb 2002 Location: Bogota, Colombia Posts: 11,927	You could hide rows 34:65536 and columns M:IV too. __________________ Regards, Juan Pablo González http://www.juanpg.com

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 10th, 2002, 11:27 AM	#1
jgoulart Board Regular Join Date: Feb 2002 Location: John G Posts: 62	Is there a way to make all but lets say range("A1:L33") hidden on worksheet? John

Mar 10th, 2002, 12:22 PM	#3
Mudface MrExcel MVP Join Date: Feb 2002 Location: Sunny, spring-like Hull Posts: 3,339	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