Using VBA to convert text to proper case

Hi folks,

I'm a complete novice with VBA (never done any coding before). I have a list of customers within excel but all the font is in both upper case and lower case.

I need to use some coding to change the font to proper case in the cell range B2:J535 (i.e. all columns from B-J and all rows from 2-535)

Is this possible? and if so can anyone shed any light on where to start? please put your responses in complete novice format because I am trying to start from scratch having never seen VBA before.

Any assistance would be very much appreciated.

Darlo

You can use this code (changing your font name, size, etc.):

Please Login or Register  to view this content.

that is the same than write:

Please Login or Register  to view this content.

Regards,
Antonio

hi,

right click the worksheet tab. Go to view code. Paste this -

Please Login or Register  to view this content.

into the window that pops up.

Hilight all the cells you cant to work on, and goto toos>macros>run macros

hth

dave

I'm sorry but I misunderstood your question.

Regards,
Antonio

Excellent, thank you!

This has worked perfectly, sorry It has taken a while to reply but I have have had to format