Thread: Change range in capital letters on load
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Kelson Kelson is offline
external usenet poster
  
Posts: 8
Default Change range in capital letters on load
Hi all

How can I change the range between B9 to B500 in capital letters.
I would like to do it in a "on load" event, not using "=UPPER" because I
dont wanna use adjacent column.

Any help?

Cheers
Kelson


Reply With QuoteReply With Quote