Hi,
I try to hide all rows exept them with A:A cells with values. I have
formulas in the cells and if the formula give "" the row should be hidden.
The formulas are references to other cells in other sheets, like "
='Sheet2'!B10 " and the reference cells are also formulas, if that matter.

I have tried with
Blad102.Range("A737:A835").SpecialCells(xlCellType Blanks).EntireRow.Hidden =
True

It doesn't work because xlCellTypeBlanks consider formulas to be "not
blanks", I guess.

The 'Sheet2'!B10 and similar cells will contain either text or ""
If 'Sheet2'!B10 gives value "" the A:A cell should be hidden, else it
shuold be visible

In some A:A cells I have manually using a few space strikes to be ensured
the rows always should be visible.

Any suggestions?

/Regards