T
Tim Childs
Hi
I found out the hard way (by searching the internet/newsgroups) that while
it
is possible to use the Count worksheet function with a declared array, as
follows:
iNewRowsRequired = WorksheetFunction.CountA(ColumnsInfo)
BUT it is not possible to use it with CountIf worksheet function.
Can someone help show me where I can find that Countif will not work with
declared arrays?
Many thanks
Tim
I found out the hard way (by searching the internet/newsgroups) that while
it
is possible to use the Count worksheet function with a declared array, as
follows:
iNewRowsRequired = WorksheetFunction.CountA(ColumnsInfo)
BUT it is not possible to use it with CountIf worksheet function.
Can someone help show me where I can find that Countif will not work with
declared arrays?
Many thanks
Tim