Macro for creating letters to UPPER letters

I have words in cell range (i.e. A1:A1000) and I want them to became upper letters.

Excel forum to EXCEL FORUM

Please macro wich I can assign to some button

I would use Evaluate

Please Login or Register  to view this content.

hi zbor
try.. something like

Please Login or Register  to view this content.

Working! Thx!

I should have added that if you wanted the range to be based on active selection then

Please Login or Register  to view this content.

(evaluate essentially allows up to update en masse without iteration - here the iteration is only per range area should you select multi non-contiguous ranges, all cells within that area are updated simultaneously)

Y, works too

(and when I said few months ago that I will start learning macro soon... I lie )