none
VB Script Question - having trouble with vbCRLF RRS feed

  • Question

  • Hi -

    I'm adding the following values to cells A1:C1:


    	objWorkbook1.Worksheets(FILE1TAB).Range("A1").Value = "Order Type COAS-AUART"
    	objWorkbook1.Worksheets(FILE1TAB).Range("B1").Value = "Order Number COAS-AUFNR"
    	objWorkbook1.Worksheets(FILE1TAB).Range("C1").Value = "Description COAS-KTEXT"

    However, I want it displayed as such:

    Order Type
    COAS-AUART


    Order Number
    COAS-AUFNR

    Description
    COAS-KTEXT

    Thanks!


    Saturday, June 23, 2018 11:53 AM

Answers

  • Does this work:

    objWorkbook1.Worksheets(FILE1TAB).Range("A1").Value = "Order Type" & vbCrLf & "COAS-AUART"


    Richard Mueller - MVP Enterprise Mobility (Identity and Access)

    • Proposed as answer by jrv Saturday, June 23, 2018 4:40 PM
    • Marked as answer by Tom LavedasModerator Tuesday, June 26, 2018 3:45 PM
    Saturday, June 23, 2018 12:07 PM
    Moderator