For improved ability to read client names in a list, I wanted to format the string "Duck, Donald" as "DUCK, Donald". Doing to task manually for a few records was no problem, though updating hundreds of records no fun at all.
So I wrote a small piece of code to do the task. I share the code here in the attachment for all who may find it it of value.
Peace out!
Is this solved?
If you solve a problem yourself before anyone else has responded, please take a moment to describe your solution, chances are some other member will benefit.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
FYI:
http://www.mrexcel.com/forum/showthr...te+normal+bold
You can't do it, if the cell contains formula.
This is just a sample
Select A1:A2, before you run the code
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks