Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Assume that you have a mailing list file. The file is currently the active workbook, and the active sheet of this workbook has full names
Assume that you have a mailing list file. The 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 BOB C. LEE). Write a sub that counts the number of names in the list with last name LEE and then displays this count in an MsgBox that is titled Number of Lees and has an Exclamation icon button. Note that there might be last names, such as KLEE, which should not be counted.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started