VBA - uppercase

Post date: May 17, 2011 9:27:03 PM

Version = StrConv(Sheets("home").Range("MF_version").Value, vbUpperCase)

Market = StrConv(Sheets("home").Range("MF_market").Value, vbUpperCase)

Flowname = StrConv(Sheets("home").Range("MF_flowname").Value, vbUpperCase)

' setup the correct mandatory field with capital letter

Sheets("home").Range("MF_version").Value = Version

Sheets("home").Range("MF_market").Value = Market

Sheets("home").Range("MF_flowname").Value = Flowname