XLCubed is now FluenceXL. The new wiki can be found here: https://help.fluencexl.com/

Difference between revisions of "XL3ColumnVisible"

(The example was the wrong way round)
Line 19: Line 19:
  
 
{{Code|1==XL3ColumnVisible( IsError( C5 ) )}}
 
{{Code|1==XL3ColumnVisible( IsError( C5 ) )}}
 +
 +
==Limitations==
 +
 +
Please see the XL3RowVisible [[XL3RowVisible#Limitations|limitations]] section for more details.
  
 
==See Also==
 
==See Also==

Revision as of 14:08, 7 August 2014

Shows and hides the column the formula is in.

Syntax

XL3ColumnVisible( Visible )

Parameters

Parameter Description
Visible If set to TRUE the column is shown; if set to FALSE the column is hidden

Examples

Shows the column if the value in cell C5 contains an error.

=XL3ColumnVisible( IsError( C5 ) )

Limitations

Please see the XL3RowVisible limitations section for more details.

See Also