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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Making Sheet all Upper Case 3
Formatting cells to only upper case 5
Format Cell - Only Upper Case Alpha characters 3
change to upper/lower case 1
how to make whole work sheet in to upper case 4
UPPER CASE 1
Changing from upper case to lower case 12
Upper Case Conversion 4

Back
Top