Hello, can you help me with this code? Itīs just a simple one but it keeps given me the Error 13- "type mismatch" when i try to define Count variable based the CountIf function. Any suggestions?
Please Login or Register to view this content.
Hello, can you help me with this code? Itīs just a simple one but it keeps given me the Error 13- "type mismatch" when i try to define Count variable based the CountIf function. Any suggestions?
Please Login or Register to view this content.
Last edited by jj4jj; 11-21-2015 at 06:46 PM.
The Workbook variable name is actually "2" so for better understanding:
Any ideas? PLSPlease Login or Register to view this content.
Any chance you could upload a sample workbook?
Click on GO ADVANCED and use the paperclip icon to open the upload window.
If posting code please use code tags, see here.
Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem - not what you think the answer might be. (think google search terms?). Once you have done this please send me a PM and I will remove this request. (Also, include a link to your thread - copy from the address bar)
Many members search our previous posts, and thread titles play a big part of the search. I doubt anybody would do a search based on your title?
To change a Title on your post, click EDIT POST then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.
(note: this change is not optional )
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are the two files
jj4jj please read post #4
The code in the file you uploaded is not the same as in post #1.
The code you posted, fails on the bolded line because x doesn't have a value when that line is run.
Did you upload the right file?
Please Login or Register to view this content.
Last edited by skywriter; 11-21-2015 at 07:06 PM.
Click the * Add Reputation button in the lower left hand corner of this post to say thanks.
Don't forget to mark this thread SOLVED by going to the "Thread Tools" drop down list above your first post and choosing solved.
Solved - type mismatch of the Range for the CountIf function:
Thus is how it looks fixed:
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks