Can I stop proper from making 's into 'S ?

[tonywatsonhelp]

Hi Everyone,

I use the proper comand in vba like this

WorksheetFunction.Proper(b.Value)

it does what i want and make the first letter a capital, but it capitalise after one of these " ' " so it changes king's to King'S
is there a way i can stop this?

thanks

Tony

 

[FormR]

Hi, have you tried VBA's strConv() function instead of the worksheet function.

StrConv(b.Value, vbProperCase)

 

[tonywatsonhelp]

Thanks FormR i'll give that a go now

 

[tonywatsonhelp]

Thanks FormR i'll give that a go now

worked perfectly thank you