hi,
Below are two examples of how i am using countifs in excel vba.
THe first one works......no issues:
However, for some reason the following produces a method range of object worksheet failed error and i can not figure out whyPlease Login or Register to view this content.
Please Login or Register to view this content.
Note: i did define the worksheets as follows:
Please Login or Register to view this content.
Bookmarks