Unhiding rows/columns in excel 2007

[ronakinuk]

how can i unhide rows/columns in excel 2007

[missinglinq]

"Code" says absolutely nothing about your problem here! I’ve re-titled your thread so that it actually reflects the question at hand. Having a title that does this clearly is important for two reasons.

First, it allows members, at a glance, to understand the nature of the question being asked. Thus, people who have never dealt with this or similar problems are saved the time and trouble of opening your thread. They would have nothing to contribute.

Secondly, and just as important, responsible people with questions first search for threads that address similar issues. Having a clear title facilitates these searches and saves everyone time and trouble.

Welcome to Bytes!

Linq ;0)>

[nico5038]

The needed code can be found by recording a macro and performing the hide / unhide action when recording.
After wards open the created macro to see the commands.

Nic;o)

[ADezii]

Here are some Code Examples that will hopefully point you in the right direction:

Dim intRowCounter As Integer
 
'Hide Column L
Columns("L").Hidden = True
 
'Hide Row 90
Rows(90).Hidden = True
 
'Hide Columns F, G, and H
Columns("F:H").Select
Selection.EntireColumn.Hidden = True
 
'Hide Rows 10 thru 16
For intRowCounter = 10 To 16
  Rows(intRowCounter).Select
  Selection.EntireRow.Hidden = True
Next
 
'Hide Columns A, B, and C on Sheet3
Worksheets("Sheet3").Columns("A:C").Hidden = True
 
'Hides Row 37 on the Active Worksheet
ActiveSheet.Rows(37).Hidden = True