Just make sure there are no formulas in the cells you select.

This code will change all to values only.


Gord Dibben MS Excel MVP

On Wed, 4 Nov 2009 10:25:13 -0800, Luke M
wrote:

using formulas, you can use the UPPER function.

via macros, you can use the UCase operator. Something like:

Sub CapMe()
For Each ws In ThisWorkbook.Worksheets
'Adjust as desired
For Each cell In ws.Range("A1:Z200")
cell.Value = UCase(cell.Value)
Next cell
Next ws
End Sub