View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Frank Kabel Frank Kabel is offline
external usenet poster
 
Posts: 3,885
Default Newbie: Error 1004

Hi
how are the other variables defined?

--
Regards
Frank Kabel
Frankfurt, Germany


Barry Aylett-Warner wrote:
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