Kanan,

I think you want to use the INDIRECT function to convert a text
string to an actual range reference. E.g.,

=COUNTA(INDIRECT(datasheet()&"!$A$A"))


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com




"Kanan" wrote in message
...
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 the
result.

This formula is not working. Any suggestions?

Thanks
Kanan