workaround named range character limit
I'm building a graph, where the series are named ranges. It all works fine as I have a dropbox, where I select the customer, and it loops through the data, creating the string for the named range and edits it, refresh the graph, voila!

Now, the problem is that it seems I have a limit of 255 characters for this string, and if a customer has a lot of records, then it errors.

Has anyone come across a similar issue or knows a workaround?

    For i = 8 To lRow
        If Sheets("Data").Cells(i, 4).Value = cmbInst.Value Then
            nRangeTrade = nRangeTrade & "Data!$A$" & i & ","
            nRangeSettle = nRangeSettle & "Data!$C$" & i & ","
        End If
    Next

nRangeTrade : 
"Data!$A$85,Data!$A$97,Data!$A$98,Data!$A$156,Data!$A$157,Data!$A$308,Data!$A$309,Data!$A$464,Data!$A$473,Data!$A$474,Data!$A$478,Data!$A$490,Data!$A$541,Data!$A$546,Data!$A$633,Da"

as you can see, this is where the problems kick in.
workaround named range character limit
===

I'm building a graph, where the series are named ranges. It all works fine as I have a dropbox, where I select the customer, and it loops through the data, creating the string for the named range and edits it, refresh the graph, voila!

Now, the problem is that it seems I have a limit of 255 characters for this string, and if a customer has a lot of records, then it errors.

Has anyone come across a similar issue or knows a workaround?

    For i = 8 To lRow
        If Sheets("Data").Cells(i, 4).Value = cmbInst.Value Then
            nRangeTrade = nRangeTrade & "Data!$A$" & i & ","
            nRangeSettle = nRangeSettle & "Data!$C$" & i & ","
        End If
    Next

nRangeTrade : 
"Data!$A$85,Data!$A$97,Data!$A$98,Data!$A$156,Data!$A$157,Data!$A$308,Data!$A$309,Data!$A$464,Data!$A$473,Data!$A$474,Data!$A$478,Data!$A$490,Data!$A$541,Data!$A$546,Data!$A$633,Da"

as you can see, this is where the problems kick in.