View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Barry Aylett-Warner Barry Aylett-Warner is offline
external usenet poster
 
Posts: 3
Default 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