I have a simple workbook with some code which includes the lines:
colb = Range("B:B")
nrows = Application.CountA(colb)
This has always been run under Excel 2003 where it works fine. However today
we ran the same code on Excel 2000 and the second line produces a type
mismatch error. Can anyone shed some light on this and provide an
alternative which will work under all versions?
Thanks
Ted
Bookmarks