YellowLabPro
10-04-2007, 01:25 AM
I am looking to create a string and maintain certain formattting w/in the string. Is what I am trying to do legal, if so, where is my error here?
Range("J11").Value = WorksheetFunction.Proper(company & Chr(32) & season & Chr(32) & year) And _
UCase(store & Chr(32) & Format(Date, "m-dd-yy"))
thx
Range("J11").Value = WorksheetFunction.Proper(company & Chr(32) & season & Chr(32) & year) And _
UCase(store & Chr(32) & Format(Date, "m-dd-yy"))
thx