How do I upshift text

H

Hayeso

Assuming the Range is A1:A20 then

Right Click the Sheet Tab and select "View Code"

Paste the following into the code window

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Dim MyCell As Range, MyRange As Range
Set MyRange = Me.Range("A1:A20")
For Each MyCell In MyRange
MyCell = UCase(MyCell)
Next
End Sub

Select File ....Close and return to Excel
 
C

CarlosAntenna

Lots of different answers. Each is correct depending on the interpretation
of the question.
Can we hear from the OP? What was the question?
 
G

Gord Dibben

Upshift.....Superscript??

Gord Dibben Excel MVP

Lots of different answers. Each is correct depending on the interpretation
of the question.
Can we hear from the OP? What was the question?
 
Top