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