That's my question.
I was able to get accurate results of counta(A:A) on a closed xlsm workbook, but countif(A:A,"*") on same workbook gave value unless I opened the workbook.
(and as to why the macro I posted just a sec ago works ACCURATELY for .xlsm files but not .xsls, xlsx files, Is Another, entirely diffferent question).
BUt im more converned with why referencing a closed .xlsm bookbook with
works first off, but doesn't by
is there something inherent in counta which enables it to work first hand, but theres something with countif that doesnt? why the disparity in performance?? behavior?? (and on closed workbooks?).
Because im thinking if Counta can work on a closed workbook, and countif cant, (or not as much) , then the same level of power/efficiency carries through to their operational behavior and perfomance when workbooks are open.
which brings me to the top question: Is there a more efficient way to reference and count ranges and rows? (on A. closed and then B. open workbooks) , than the "count" family of functions???
I was able to get accurate results of counta(A:A) on a closed xlsm workbook, but countif(A:A,"*") on same workbook gave value unless I opened the workbook.
(and as to why the macro I posted just a sec ago works ACCURATELY for .xlsm files but not .xsls, xlsx files, Is Another, entirely diffferent question).
BUt im more converned with why referencing a closed .xlsm bookbook with
Code:
counta
Code:
countif
is there something inherent in counta which enables it to work first hand, but theres something with countif that doesnt? why the disparity in performance?? behavior?? (and on closed workbooks?).
Because im thinking if Counta can work on a closed workbook, and countif cant, (or not as much) , then the same level of power/efficiency carries through to their operational behavior and perfomance when workbooks are open.
which brings me to the top question: Is there a more efficient way to reference and count ranges and rows? (on A. closed and then B. open workbooks) , than the "count" family of functions???