Thread: Error 1004
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tigger Tigger is offline
external usenet poster
 
Posts: 2
Default 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.