error trying to use vba countifs function

[welchs101]

I have two workbooks

i have this code which gives me an error

Please Login or Register  to view this content.

any idea why it does not work?

[shg]

Are all those things declared variables?

[welchs101]

they are ranges........see code below

Please Login or Register  to view this content.

[welchs101]

ok...not sure why but i changed the set ranges all the same starting point.....some were 1 and some were 2..........changed all starting points of the ranges to "1" and it works......i think........

Please Login or Register  to view this content.

[shg]

All the ranges in CountIf(s) have to be the same size, just as when used on a worksheet.

[welchs101]

thanks.......for your help.