Error 1004
Hi,
Can anyone please help with the following:
1004 Application-defined or object-defined error.
....... lots of code
xstart = "555"
For j = 1 To nump
Debug.Print Worksheets("Sheet2").Cells(j, 1).Value, xstart
Worksheets("Sheet2").Cells(j, 1).Value = xstart
....... lots more code
The debug.print prints the correct values from the spreadsheet and the
program variable. It gives the error on the next line when trying to
set the value.
|