Hi
Is it possible to mix EXCEL functions and User Defined FUnctions in a formula
e.g In Cell "A", =COUNTA(datasheet()!$A:$A)
where datasheet is a UDF to get another sheet name and then COUNTA should use that sheetname to calculate the th
result

This formula is not working. Any suggestions

Thank
Kanan