Results 1 to 3 of 3

Thread: Question about concatenate

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1
    VBAX Wizard lucas's Avatar
    Joined
    Jun 2004
    Location
    Tulsa, Oklahoma
    Posts
    7,321
    Location

    Question about concatenate

    FireFyter posted this code to a previous post:

    Dim start As Long, lastRow As Long 
    start = 4 
    lastRow = ExcelWS1.Range("A65536").End(xlUp).Row 
    Do 
        ExcelWS1.Range("F" & start).Value = _ 
        ExcelWS1.Range("G" & start).Value & ExcelWS1.Range("H" & start).Value & _ 
        ExcelWS1.Range("I" & start).Value & ExcelWS1.Range("J" & start).Value & _ 
        ExcelWS1.Range("K" & start).Value & ExcelWS1.Range("L" & start).Value 
        start = start + 1 
    Loop Until start > lastRow


    I was wondering how you would put a space or a hyphen between the merged data in column F.


    Last edited by Aussiebear; 04-29-2023 at 08:42 PM. Reason: Adjusted the code tags

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •