Just on top of my head (not tested):


Dim TCell As Range

For Each TCell In Range("B:B")
TCell.Value = UCase(TCell.Value)
Next


Give it a try :-)



Chris Hankin wrote:
Hello,

Could someone please advise on how I can change text to uppercase in
column B of my worksheet using Excel 2003 - I do not wish to add any
more columns, so I guess a VBA macro might be required? I usually
enter mixed-case text into a cell in column B, so I wish to have this
mix-case text automatically change to uppercase please.

Thanks,

Chris.



*** Sent via Developersdex http://www.developersdex.com ***