Assume you have a mailing list file. this file is currently the active workbook, and the active sheet of this workbook has full names in column A, starting in cell A1, with last name last and everything in uppercase letters (such as Stephen E. Lee). Write a sub that counts the number of names in the list with last name Lee and then displays this count in a MsgBox. Note that there might be last names such as KLEE, which should not be counted.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
VBA for modeleres question Ch 7 Prob 16 4th edition
- Thread starter riri1015
- Start date
Similar threads
- Question
