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?
--
Thanks
Shawn
From: Jacob Skaria on 25 Jan 2010 08:24
Try

Sub Macro()
Dim cell As Range
For Each cell In Range("A1:A10")
If Not cell.HasFormula Then cell.Value = UCase(cell.Value)
Next
End Sub

--
Jacob


"Shawn" wrote:

> I need a code that will search a range (say, A1:A10) and convert everything
> in that range to all caps?
> --
> Thanks
> Shawn
 | 
Pages: 1
Prev: ActiveWorkbook.SaveAs Function - Can I specify the user account to save the file with
Next: Unexpected internal error or not enough memory