Use the following code, place the code in the ThisWorkbook Code Pane.
Sub SelectionToUpper()
Dim cl as Range
Application.EnableEvents = False
For Each cl in Selection.cells
if cl.HasFormula = False then
cl.value = Format(cl.value, ">")
endif
Next cl
Application.EnableEvents = True
End Sub
Before running this Macro from Tools->Macro->Macros, on the worksheet,
select the cells you want to convert to upper case, and then run the macro.
This way you don't have to insert any temporary columns in the worksheet,
and the cells are converted to upper case instantly.
Regards
Ajit
On Sun, Sep 21, 2008 at 2:38 PM, vijender kumar <[EMAIL PROTECTED]>wrote:
> Hi,
>
> Just use this formula =upper(cell reference)
>
> On Sat, Sep 20, 2008 at 5:22 PM, vinay keni <[EMAIL PROTECTED]> wrote:
>
>> dear all,
>>
>> i want to know how to change from small letters to capital
>> letters as i have some 500 persons name which i have typed in small letters
>> now wants to change those things in the Big letters ..... reply fast its
>> urgent
>>
>> --
>> Regards,
>> Vinay Keni
>>
>>
>
> >
>
--
Thank You,
Ajit Navre
--~--~---------~--~----~------------~-------~--~----~
Visit the blog to download Excel tutorials at
http://www.excel-macros.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/excel-macros?hl=en
Visit & Join Our Orkut Community at
http://www.orkut.com/Community.aspx?cmm=22913620
Visit the blog to download Excel tutorials at
http://www.excel-macros.blogspot.com
To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com
To see the Daily Excel Tips, Go to:
http://exceldailytip.blogspot.com
-~----------~----~----~----~------~----~------~--~---
