Thread: Hide/Unhide Rows or Columns
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Greg Glynn Greg Glynn is offline
external usenet poster
  
Posts: 137
Default Hide/Unhide Rows or Columns
You can't hide a range, but you can hide colums and rows:
Some examples:
Columns("E:F").EntireColumn.Hidden = True
Columns("D:G").EntireColumn.Hidden = False
Rows("8:8").EntireRow.Hidden = True

2007-User wrote:
Hi,

How can I Hide/Unhide rows/columns or a ranges?

Thanks in advance.

Reply With QuoteReply With Quote