set visible range
 

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

set visible range
 

Hi,

As far as I'm aware you can't

Mike

"Atishoo" wrote:

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

set visible range
 

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

"Mike H" wrote:

Hi,

As far as I'm aware you can't

Mike

"Atishoo" wrote:

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

set visible range
 

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


"Atishoo" wrote:

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

set visible range
 

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

"Office_Novice" wrote:


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


"Atishoo" wrote:

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

set visible range
 

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.

Atishoo wrote:

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

--

Dave Peterson