Application-defined or object-defined error
My VBA application is writing to a Office XP Excel sheet. However, if I click on the cells during the writing process there is an error thrown at the point of the .Cells().value:
'Row is some row number
.Cells(Row, 1).value = 'some value
This error is Application-defined or object-defined error. It appears that excel loses its cell position. Once the function is recalled Excel is able to continue without an error.
Does anyone know what causes this.
Thanks in advance.