Hi Topola
tabblad = sheet
Arjan have sheet names in col A and want a formula in col B to check if that sheet exist.
My answer do that
=IF(ISERR(INDIRECT($A1&"!A1")),"Not exist","exist")
Or in Dutch
=ALS(ISFOUT2(INDIRECT($A1&"!A1"));"Not exist";"exist")
--
Regards Ron de Bruin
http://www.rondebruin.nl
"topola" wrote in message ups.com...
Ik kan niet "tabblad" verstanden - is het English "table" or bedoel je
het algemeen formula?
Tomek Polak