>>Has anybody used The CountA function in Excel 97.
>>
>>
>>I've used in previous excel versions, in the following syntax:
>>
>> Workbooks(1).Worksheets(1).Application.CountA("A1:A8")
>>
>>When I run it from Excel 97. I get a "Method does not exists" error message.
>>
>>Any Ideas??????????
>>
>>Marios Patsias
>
>I know it is not the answer you want but I haven't found another one.
>
>After some search I have not discovered how we can call this function from VBA but we can call it from a formula directly on the worksheet. So why not include this formula on your worksheet and read the value of the cell.
>
>If you don't want the user to see the formula, you can create a macro that will create the formula, read the value and then, delete the formula!
Thanks.
It may not seem to be the best way, but it surely works!
Marios
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement