Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Run time error 1004, General ODBC error | New Users to Excel | |||
Runtime error '1004' General ODBC error | New Users to Excel | |||
Excel 2003 Macro Error - Runtime error 1004 | Excel Discussion (Misc queries) | |||
VBA error - run-time error '1004': | Excel Programming | |||
Error 1004 help | Excel Programming |