Newbie: Error 1004
I'm trying to read a set of array values into an excel worksheet. I can
transfer single values OK, but run into trouble when I try to do it in a
For..Next loop, getting a '1004' error.
eg
For x=0 to 23
ws.Cells(xlRow,xlCol) = Scores(y,x)
xlCol=xlCol+1
Next
Having tried to research the problem, I know that the problem lies with the
iterated call to Excel, but can't get the syntax correct.
Can anyone help please?
Thanks
Barry
|