Help with Excel VBA Problem?

[BrooksyX]

Can someone help me code the following VBA problem:

"Assume you have a mailing list file. This file is currently the active workbook, and the active worksheet of this book has full name in coloumn starting in cell A1, with the 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 the count in a MsgBox. Not that there might be last names such as KLEE, which should not be counted."

Thanks!

 

[Danith]

homework?

You could probably do something with the InStrRev function (http://www.w3schools.com/vbscript/func_instrrev.asp) and have it locate the first " " (from reverse) and then use Right (http://www.w3schools.com/vbscript/func_right.asp) to get the characters up to that location... and loop through the cells and store the results

I'm way to tired to do it for you though

 

[PTNL]

Yep, definitely homework... specifically question 16 from Chapter 7 in this book:
VBA for Modelers: Developing Decision Support Systems with Microsoft Office Excel

We can help you, but you have to first show the proof that you've made an investment into figuring out the solution (besides buying the book).

 

[BrooksyX]

yeah it was homework. But already turned it it, was due ad midnight oh well. I got the rest of chapter 7 done. I am going to ask the professor to go over it in class today.