Hello!

I wrote this simple code to change the case in a cell to proper when a
macro button is pushed, but it doesn't work.


I don't get any errors, but when I run the macro, the screen just
blinks like something is happening, but I don't know what?

Where's the problem?

Sub CaseChange()
Formula = "Proper(A1)"
End Sub

Thanks,
EMoe


--
EMoe
------------------------------------------------------------------------
EMoe's Profile: http://www.excelforum.com/member.php...o&userid=23183
View this thread: http://www.excelforum.com/showthread...hreadid=373999