Hi Team,

With help from this forum I have become reasonably adept at bringing back a single cell value from another workbook using this code as an example

With ThisWorkbook.Sheets(sheet_name).Range("B14")
    .Formula = "='" & ThisWorkbook.Path & "\[" & property_register & "]" & property_id & "'!B6"
    .Value = .Value
End With
My current challenge (ie. issue / problem ) is this:

I really would like to return a string that is the concatenation of (in this case) cells B6, B7, B8 & B9 but despite experimenting with various code solution have dismally failed to get the right result (the cells in question contain a "fielded" address in an different workbook and I want to "join them together" for simple one line summary display in the primary workbook)

In practice, I can probably live with just the first cell as that will generally be enough information to the end user but the full address would be much better

Cheers

Jmac