Excel Code to change to UPPER Case

[Dreamboat]

I know there's some code that will easily change, for instance, all entries into column A into capital letters. Anybody paste it please?? DESPERATE!!
techsupportgirl@home.com

http://www.PiersonTech.com

Brainbench MVP for Microsoft Word

 

[JVFriederick]

=UPPER(A1)
COPY TO ALL ROWS.

 

[Dreamboat]

Nope. Sorry. Need VBA CODE. And I know you know it, JV! I want it!! LOL
techsupportgirl@home.com

http://www.PiersonTech.com

Brainbench MVP for Microsoft Word

 

[Dreamboat]

Sorry. It's either change or worksheet change event.
techsupportgirl@home.com

http://www.PiersonTech.com

Brainbench MVP for Microsoft Word

 

[JVFriederick]

Something must be slow on my end.... I just got your new request........


Sub ChangeCase()

Application.Cursor = xlWait ' Smoothes out the macro execution
Application.ScreenUpdating = False ' Makes macro run faster

For IntR = 1 To 10000
ActiveSheet.Rows(IntR).Columns(1) = UCase(ActiveSheet.Rows(IntR).Columns(1))
Next IntR

Application.Cursor = xlDefault ' Set cursor back to default.

End Sub

 

[Dreamboat]

I've since some other fairly different looking code, but I want to try yours too. The problem's been resolved with the other code on the user end, but I must have asked this question a gazillion times and never save the dern code.

I'm in Chapter 12 of the Riley Excel VBA book...have patience with me! LOL LOL

Thanks!
techsupportgirl@home.com

http://www.PiersonTech.com

Brainbench MVP for Microsoft Word