XLCubed101

I didn't see explicitly mentioned in the manual , although you can sort assume it based on " XL3Link( [LinkLocation], [FriendlyName], [LinkType], [Range1], [Value1],…, [Range13], [Value13] ) ". There is a limit of 13 on the number of Range / Value combos you can make. This will work: =XL3Link(XL3Address($B$1) , IF(Parameters!$B$01=TRUE,"-","+"),3 ,XL3Address(Parameters!$B$01),IF(Parameters!$B$01=TRUE,FALSE,TRUE) ,XL3Address(Parameters!$B$02),IF(Parameters!$B$02=TRUE,FALSE,TRUE) ,XL3Address(Parameters!$B$03),IF(Parameters!$B$03=TRUE,FALSE,TRUE) ,XL3Address(Parameters!$B$04),IF(Parameters!$B$04=TRUE,FALSE,TRUE) ,XL3Address(Parameters!$B$05),IF(Parameters!$B$05=TRUE,FALSE,TRUE) ,XL3Address(Parameters!$B$06),IF(Parameters!$B$06=TRUE,FALSE,TRUE) ,XL3Address(Parameters!$B$07),IF(Parameters!$B$07=TRUE,FALSE,TRUE) ,XL3Address(Parameters!$B$08),IF(Parameters!$B$08=TRUE,FALSE,TRUE) ,XL3Address(Parameters!$B$09),IF(Parameters!$B$09=TRUE,FALSE,TRUE) ,XL3Add...

One of our user had the need for a button to "Show" or "Hide" the monthly details in order to avoid report clutter: This how we did it: On the parameters sheet we added an entry for each column we might want to hide: On the top row of our data sheet we added the following formules: =XL3ColumnVisible(Parameters!$B1) =XL3ColumnVisible(Parameters!$B2) =XL3ColumnVisible(Parameters!$B3) =XL3ColumnVisible(Parameters!$B4) etc Once you have tested everything you can hide this row! In Cel B3 we added the following formula: = IF(Parameters!B1=FALSE, XL3Link(XL3Address($A$1),"Show Details",3 ,XL3Address(Parameters!$B$1),TRUE ,XL3Address(Parameters!$B$2),TRUE ,XL3Address(Parameters!$B$3),TRUE ,XL3Address(Parameters!$B$4),TRUE ,XL3Address(Parameters!$B$5),TRUE ,XL3Address(Parameters!$B$6),TRUE ,XL3Address(Parameters!$B$7),TRUE ,XL3Address(Parameters!$B$8),TRUE ,XL3Address(Parameters!$B$9),TRUE ,XL3Address(Parameters!$B$10),TRUE ,XL3Addres...