Upper case a worksheet

D

D M P

I have an excel file that is upper/lower in case. I need to make this file (columns B, C, D, E & F)
all upper case. I realy don't understand what the help window is trying to tell me. Will someone please show or tell me how to go about this.

Diane
 
D

David McRitchie

Hi Diane,
See my page http://www.mvps.org/dmcritchie/excel/proper.htm#upper

For the event macro you would modify appropriate line to
if target.column < 2 or target.column > 6 then exit sub
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

I have an excel file that is upper/lower in case. I need to make this file (columns B, C, D, E & F)
all upper case. I realy don't understand what the help window is trying to tell me. Will someone please show or tell me how to go
about this.

Diane
 
Top