Changing letter case on mass

Hi Guy's,

Thanks for your posts

I tried the PROPER() way, but it was too simple for me as I couldn't get it to work? However.... I also tried the VB code and it worked So I'm well pleased.

I'll have another play with the PROPER() code to try and see why I couldn't get it to work.

Thanks again for your help

hi gents

im trying to learn excel in every way and although i never will
i always try the suggestions on this board to se eif one day they will help me

ive tried this macro and cant get it to run for me

i input my data and then run the macro but nothing happens

why is this