Upper case a worksheet

[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

 

[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


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