Hide/Unhide Rows or Columns
 

Hi,

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

Thanks in advance.

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.

Hide/Unhide Rows or Columns
 

Rows/Columns yes, range no

rows("1:10").hidden=true

columns("D:H").hidden = true

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"2007-User" wrote in message
...
Hi,

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

Thanks in advance.

Hide/Unhide Rows or Columns
 

Thanks Guys.


"Bob Phillips" wrote in message
...
Rows/Columns yes, range no

rows("1:10").hidden=true

columns("D:H").hidden = true

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"2007-User" wrote in message
...
Hi,

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

Thanks in advance.