VBA Collection help - read /write bank accounts in string

[Mallesh23]

Hi Team,

I want to read Bank accounts of Column A via collection
and print out bank accounts back in Column B.

Attached expected output snapshot

Sub coll()

Dim coll As New Collection
Dim i As Long

'Read Data from worksheet
    For i = 2 To 7
        coll.Add Range("A" & i).Value
    Next i


'WriteData back to worksheet in Column C.
For i = 1 To coll.Count
    Range("C" & 1 + i).Value = coll(i)
Next i

View attachment 14932


End Sub

 

[Fluff]

Rather than posting an invalid image, please post some sample data using the XL2BB add-in & explain why your code is not working as expected.