Change to UPPERCASE - My VBA Macro Imports lowercase data Sheet 1 to lowercase Sheet 2?

[John.McLaughlin]

Hello!

I use a basic order form clients fill out and send me. Then I have a VBA macro that reads every cell of the submitted form, and pastes the value into the corresponding "In House" form.

Trouble lately, a few people are sending everything in lower case. Can I modify my copy or paste command to convert this to uppercase?

Thanks in advance!

'copy the Cell from source book
    wbThis.Sheets("ORDER").Range("J4").Copy
    '
    'paste the data on the target book
    wbTarget.Sheets("ORDER").Range("F8").PasteSpecial xlPasteValues


    ' This is the end of code for individual cell copy ORDEREDBY

 

[Fluff]

Glad we could help & thanks for the feedback