selection value in uppercase

[sunnytahir]

i want to change the value of selection (some rows & columns) in uppercase in excel.

 

[Zathras]

If you mean you want to change the text in all of the selected cells to upper case, here is one way:
[blue]

Sub UpperCaseSelection()
Dim c As Range
  Application.ScreenUpdating = False
  For Each c In Selection
    c.Value = UCase(c.Value)
  Next c
  Application.ScreenUpdating = True
End Sub

[/color]