set visible range

[Atishoo]

Sorry to ask such a no brainer !!
How do i set a range as visible or not visible like you would an object?

ie range ("main board") visible = false

 

[Mike H]

Hi,

As far as I'm aware you can't

Mike

 

[Atishoo]

aaarghdamn blast is there a way of setting it as hidden or perhaps covering
the range with a blank object?

 

[Office_Novice]

Columns("C:C").Hidden = True

 

[Atishoo]

thanks but it doesnt seem to work for a range despite it working for a column
as your example shows
thanks again

 

[Dave Peterson]

You could hide the entire row or column.

Maybe you could format the font's color so that it matches the fill's
color--white on white would make it look like the range was hidden.

You may be able to use format|conditional formatting for this.

Or maybe you could give the range a custom format:
;;;
(3 semicolons)

The cell will look empty.

You'd still see the value/formula in the formula bar for all these, though.