Hi,
Thanks for all those who have been kind enough to help me, i've really learned a lot since starting to use Excel and VBA. This Forum and its contributors have been the best help i have found, so thank you!
In a previous post i required a COUNTIF function and i was shown how to which lead to the following code;
Please Login or Register to view this content.
This works perfectly....
Since going through some of my other Formulas as they were displaying the '#VALUE!' error message i discovered that i didn't apply the COUNTIF on some functions after my ',AND' function. Here is one of them;
Please Login or Register to view this content.
As you can probably see, half way through i have;
Obviously the part '$AA$1=$AA$71:$AA$77' is just wrong and i know i have to wrap this using the COUNTIF function again.Please Login or Register to view this content.
How do i achieve this in the second part of the code?
Many thanks for looking and taking the time to help me guys! Any help greatly appreciated!
Bookmarks