Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
All-in-one printing incompatibility with EXCEL in landscape mode | New Users to Excel | |||
Windows Vista and Excel 2000 -- incompatibility? | Excel Discussion (Misc queries) | |||
Time for M$ to fix incompatibility with Office & Works | Excel Discussion (Misc queries) | |||
Excel 2000 v 2003 Macro & VBA Incompatibility | Excel Programming | |||
Incompatibility between Excel97 and Excel95 macros | Excel Programming |