P
pcor
I would like a macro that would set the "proper" format for the cell selected.
Thanks
Thanks
Shane Devenshire said:Hi,
For Proper you need to call the worksheet function but for upper and lower
you must use UCase and PCase
c.Value = UCase(c.Value)
--
If this helps, please click the Yes button.
Cheers,
Shane Devenshire