Change to Uppercase in a range

[goranimo]

Hi gurus,

I want to change to Uppercase in a range from E2 until the last cell in column E that contains text.

I can get this to work if I use a specific range, i.e E2:E50, but i want it to find the range based on the last row with text

This is the code I have tried:

Please Login or Register  to view this content.

Any suggestions?


Windows 7
Office 2013

[jindon]

Short cut notation of evaluate method [] doesn't accept variable.
Change to

Please Login or Register  to view this content.

[goranimo]

Awesome, thank you!!!