Hi Experts
I have found numerous examples of how to convert ranges/selections of cells to UpperCase, LowerCase & InitalCaps) by using a loop. Although it is much fast to have it done using the formula here:
[$G$10:$G$20] = [INDEX(UPPER($G$10:$G$20),)]
question:
How can I use the same formula for using a Variable instead of the references?
the 2 examples subjoined do not work:
Dim strSelection as Range
strSelection = Selection
[strSelection] = [INDEX(UPPER(strSelection),)]
Dim Addr As String
Addr = Selection.Address
[Addr] = [INDEX(UPPER(Addr),)]
I already searched the net, but no real answer there.
This must be simple, but it's off limits for a layman
Thx for the help
I have found numerous examples of how to convert ranges/selections of cells to UpperCase, LowerCase & InitalCaps) by using a loop. Although it is much fast to have it done using the formula here:
[$G$10:$G$20] = [INDEX(UPPER($G$10:$G$20),)]
question:
How can I use the same formula for using a Variable instead of the references?
the 2 examples subjoined do not work:
Dim strSelection as Range
strSelection = Selection
[strSelection] = [INDEX(UPPER(strSelection),)]
Dim Addr As String
Addr = Selection.Address
[Addr] = [INDEX(UPPER(Addr),)]
I already searched the net, but no real answer there.
This must be simple, but it's off limits for a layman
Thx for the help