Upper case a worksheet

  • Thread starter Thread starter D M P
  • Start date Start date
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
 
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
 
Back
Top