Prev: ActiveWorkbook.SaveAs Function - Can I specify the user account to save the file with
Next: Unexpected internal error or not enough memory
From: Shawn on 25 Jan 2010 08:21
I need a code that will search a range (say, A1:A10) and convert everything
in that range to all caps?
From: Jacob Skaria on 25 Jan 2010 08:24
Dim cell As Range
For Each cell In Range("A1:A10")
If Not cell.HasFormula Then cell.Value = UCase(cell.Value)
> I need a code that will search a range (say, A1:A10) and convert everything
> in that range to all caps?