LinkBack URL
About LinkBacks
I'm putting a check into some code to make sure certain range, all the cells equal 100%
My code is as follows;
When i run the code i get an error of type mismatch?
Please Login or Register to view this content.
I'm putting a check into some code to make sure certain range, all the cells equal 100%
My code is as follows;
When i run the code i get an error of type mismatch?Please Login or Register to view this content.
Hi,
That's because you're asking for the Value of a Range. Individual cells have values, whole ranges don't have a single value.
Incidentally the way I always handle these sorts of checks is to use a named helper cell in the workbook (name it 'Check' if you like) which uses the IF test and results in either "OK" or "Not OK"
Then just test the helper cell in VBA. e.g.
Please Login or Register to view this content.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
I believe that you need a sum function to add the values in J3:J23
Something along these lines
Please Login or Register to view this content.
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks