invalid qualifier when trying to read from array

Hi

Have searched and found huge amounts on arrays but can't seem to find what is wrong with mine
Anyway, I am basically reading a list from a column into an array and then when I try to read it back later, I get an "invalid qualifier error".

 Dim LastRow As Long
    LastRow = NWB.Worksheets("clients").Range("A65536").End(xlUp).Row
    ReDim ClientArray(LastRow) As String
    Dim i As Integer
    NWB.Worksheets("clients").Range("A1").Select
    i = 1
    Do
        ClientArray(i) = ActiveCell.Value
        i = i + 1
        ActiveCell.Offset(1, 0).Select
    Loop Until IsEmpty(ActiveCell.Offset(1, 0).Value)
    
'Code Above works and populates the array

    i = 1
    For i = LBound(ClientArray) To UBound(ClientArray)
        ActiveCell.Offset(1, 0).Select
        Call CreateClientPivotTable(ClientArray(i).Value, NWB) ' I Get compile error on this line
    Next i

Any help appreciated

hi rwilsonie,
Welcome to the forum.
whats in the sub "CreateClientPivotTable"?