Re: How do I change case from lower to proper in a range of cells?

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Paul B (newspab_at_surfbest.net)
Date: 10/12/04 

Date: Tue, 12 Oct 2004 06:52:14 -0400

Ajayjeet, you could use the upper functon like this, with data in column A
in B1 put =UPPER(A1) and copy down, then copy and paste special over your
data, or with a macro, select your data then run this code

Sub Make_CAPS()
Dim cel As Range
For Each cel In Intersect(Selection, _
Active***.UsedRange)
cel.Formula = UCase$(cel.Formula)
Next
End Sub 

-- 
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2000 & 2003
** remove news from my email address to reply by email **
"Ajayjeet" <Ajayjeet@discussions.microsoft.com> wrote in message
news:101BE42C-4C05-410C-8463-407FA19B0ECB@microsoft.com...
> I need to change case from Lower to UPPER for a range of cells. Any
pointers
> on this will be appreciated.
Quantcast