Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Set Range of Visible Cells | Excel Programming | |||
Count Visible Range? | Excel Programming | |||
Set Visible Range | Excel Programming | |||
Setting visible range | Excel Programming | |||
Sum only visible cells within a range. | Excel Programming |