|
Posted to microsoft.public.excel.programming
|
|
|
Convert all text in a sheet to UpperCase?
See
http://www.mvps.org/dmcritchie/excel/proper.htm#upper
In article ,
Rich wrote:
Hello,
Is there a command to convert all text in a sheet to UpperCase in one shot?
Or do I have to loop?
Dim rng As Range, i As Integer, j As Integer
set rng = Sheet1.UsedRange
For i = 1 to rng.Rows.Count
For j = 1 to rng.Columns.count
rng(i,j) = ConvertToUpperCase(rng(i,j) '-- a udf, pseudo code whatever
Next
Next
Thanks,
Rich
|