Hi,

I try another angle to solve my last question, becauser of lack of
answers

Any suggestion how all hidden values become "100%" as soon as the rows
become hidden. (... by my code
"Columns("AE:AE").SpecialCells(xlCellTypeFormu las, 4).EntireRow.Hidden
= True" in a routine. )

Range("P20:Y100").SpecialCells(xlCellTypeVisible). Value = "100%" would
be greate to use, if I could change it to "xlCellTypeHidden" instead,
but ...

Any idea how to "invert" a selection, maybe? I have a larger range and
one range with xlCellTypeVisible identified - how to find out the
hidden cells?


Any ideas?

/Regards
Tskogstrom