NORRILLOUS
New Member
- Joined
- Apr 10, 2014
- Messages
- 36
- Office Version
- 365
- Platform
- Windows
I found a script online that I have been using for sometime now and it works very well. All it does is go through a range A2:A1000 and changes every lower case letter to upper case. The issue I have is it really slows things down when I am trying to work and save. I would like to know is it possible to change it to only look at the cells that have values? Current code is below;
Thank you in advance!
VBA Code:
' Loop to cycle through each cell in the specified range.
For Each x In Range("A2:A500")
' Change the text in the range to uppercase letters.
x.Value = UCase(x.Value)
Next
Thank you in advance!