Change Contents of Active Cell to Upper Case

Morning, Gurus. It will take you guys about 2 seconds to figure this one out.

All I'm trying to do is change the contents of my active cell to upper case letters via VBA.

I know I can use a formula, =UPPER("RANGE"), but I don't know enough to convert that to VBA. I want to use the last cell in the worksheet to enter the formula, because that cell is never in use, and then just copay and paste the values from the formula back to the active cell. Here is what I have come up with so far. Thanks in advance for any help you can offer.

Please Login or Register  to view this content.

LCase --> LOWER, UCase --> UPPER

I'm not sure if that answers my question, KOKO. I'm guessing you are saying there is a better way to do it, like maybe in the active cell itself rather than using formula and copy/paste values. Could you please clarify how these would be used? Again, my goal is to hotkey my macro so it I want to change my active cell to upper all I have to do is hit Ctrl+U. I also tried the code below after seeing your response, but it doesn't work:

Please Login or Register  to view this content.

Thanks.

Originally Posted by [email protected]

change the contents of my active cell to upper case letters via VBA.

Overwrite cell value with its UPPERcase content:

Please Login or Register  to view this content.

for active cell it can be

Please Login or Register  to view this content.

assign Ctrl+U to this :-)

Originally Posted by [email protected]

KOKOSEK

If you don't mind.

You welcome.
IF you happy with solution, please use thread tools and marked thread as SOLVED.