Alter propecase macro to run if cell content is all caps

[capson]

I want to run the macro only if the cell has ALL Caps or only on the Part to the right of the "," is ALL caps but I can not figure out how to test for this last part

BOB BOBERSON, Ph.D. this is not all caps and I want Bob Boberson, Ph.D which the macro will give me but I do NOT want to run the macro on any other cells since it seem impossible to figure out all the combinations of name and there proper case, If some one wrote there name such that it is NOT all caps I just want to leave it alone.

Thanks

Please Login or Register  to view this content.

[Kenneth Hobson]

Use Ubound() to get the last element of an array that was Split(). Compare that in an If() where you use UCase() of that element compared to the element. You are part way there already. Just add these concepts.

[TMS]

Maybe:

Please Login or Register  to view this content.

Regards, TMS

[capson]

Kenneth Hobson, this works, is this what you were thinking from your comments?

TMShucks, thanks for the code you answered my question alas my question was poorly written and did fully reflect what I needed.

Thank you both

Please Login or Register  to view this content.

[TMS]

Glad you have a solution that works for you


Regards, TMS




If you are satisfied with the solution(s) provided, please mark your thread as Solved.


New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save


You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.