Hi,

Using xl2000 my string is truncated to 256 characters. The point of
the loop below is to extract only the rows that are numeric (skip
nulls entered by user as a space) for plotting so that the axes remain
sensible. The macro's running in a module. No problem with the yPlot
string however the xPlot string is truncated at 256 characters and
causes subsequent problems. How can I get around this?

Thanks,
ljorn

Set vcRng = ActiveSheet.Range("G11:G18").Cells

Do Until ii = 9
If IsNumeric(vcRng(ii)) Then
If IsNumeric(tmRng(ii)) Then
If ii = 1 Then
yPlot = vcRng(ii).Address(RowAbsolute:=False, _
ColumnAbsolute:=False, ReferenceStyle:=xlA1)
xPlot = "=(" & tmRng(ii).Address(ReferenceStyle:=xlR1C1, _
External:=True)
Else
yPlot = yPlot & "," & vcRng(ii).Address(RowAbsolute:=False, _
ColumnAbsolute:=False, ReferenceStyle:=xlA1)
xPlot = xPlot & "," &
tmRng(ii).Address(ReferenceStyle:=xlR1C1, _
External:=True)
End If
End If
End If
ii = ii + 1
Loop
' xPlot = xPlot & ")"

...
ActiveChart.SeriesCollection(1).XValues = xPlot ' TRUNC. therefore
error