Pasting multiple columns and rows of a listbox inyo a bookmark

[AndyE]

Hi

Can anyone help?

I have a listbox which contains two columns. This listbox may contain one row or many rows.

I have the code below which drops a single row into a bookmark. My problems begin when I have more than one row to drop in, in that I can't figure out how to....

What I want to happen is as follows...

One row only...
Row #1 data<full stop>

Two or more rows...
Row #1 data <comma>
Row #2 data <comma>
Row #3 etc.
Finishing off with a <full stop>

Dim i As Long, StrAttended As String
    
   For i = 0 To Listbox1.ListCount - 1
    Listbox1.Selected(i) = True
    StrAttended = Listbox1.List(i, 0) & Listbox1.List(i, 1) & "."
        
    Next

[AndyE]

Sorted it.....sorry.

[arlu1201]

If you solve a problem yourself before anyone else has responded, please take a moment to describe your solution, chances are some other member will benefit.