By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,030 Members | 2,277 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,030 IT Pros & Developers. It's quick & easy.

Unhiding rows/columns in excel 2007

P: 15
how can i unhide rows/columns in excel 2007
Feb 13 '10 #1
Share this Question
Share on Google+
3 Replies


missinglinq
Expert 2.5K+
P: 3,532
"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)>
Feb 13 '10 #2

nico5038
Expert 2.5K+
P: 3,072
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)
Feb 14 '10 #3

ADezii
Expert 5K+
P: 8,638
Here are some Code Examples that will hopefully point you in the right direction:
Expand|Select|Wrap|Line Numbers
  1. Dim intRowCounter As Integer
  2.  
  3. 'Hide Column L
  4. Columns("L").Hidden = True
  5.  
  6. 'Hide Row 90
  7. Rows(90).Hidden = True
  8.  
  9. 'Hide Columns F, G, and H
  10. Columns("F:H").Select
  11. Selection.EntireColumn.Hidden = True
  12.  
  13. 'Hide Rows 10 thru 16
  14. For intRowCounter = 10 To 16
  15.   Rows(intRowCounter).Select
  16.   Selection.EntireRow.Hidden = True
  17. Next
  18.  
  19. 'Hide Columns A, B, and C on Sheet3
  20. Worksheets("Sheet3").Columns("A:C").Hidden = True
  21.  
  22. 'Hides Row 37 on the Active Worksheet
  23. ActiveSheet.Rows(37).Hidden = True
Feb 14 '10 #4

Post your reply

Sign in to post your reply or Sign up for a free account.