View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Pat Pat is offline
external usenet poster
 
Posts: 122
Default Format cell to uppercase using code

When K11 contains the value "QS" and it is entered in lowercase I want to
use code to convert the characters to uppercase. The cell is formatted to
accept text and can contain other values.

Here is my attempt at writing part of the code. Need help to complete it.

If Not IsEmpty(Cells(21, 11)) Then
..Value = "qs"

Thanks if you can help.
Pat