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