Dreaded Runtime Error 1004.
 

I'm encountering the dreaded Error 1004 from the following line of code:

ActiveSheet.Cells(rngCurrRow.Row, colAccount).Value = ""

There are valid values in the parms for .Cells. This was working for a long
time and now something has changed and I don't know what. I suspect something
besides this actual line of code like some option or other factor. This runs
fine on a different system.

I've turned off WS Protection, cell validation, Set General Format.

Any ideas? Thanks,
John S.

Dreaded Runtime Error 1004.
 

What happens if you do this

'' Ctrl-g to view Immediate window
Debug.Print rngCurrRow.Row
Debug.Print colAccount ' between 1-65536 or 1-1048576 in 2007
Debug.Print TypeName(ActiveSheet)
Debug.Print ActiveSheet.Cells(rngCurrRow.Row, colAccount).Address

Regards,
Peter T



"DocBrown" wrote in message
...
I'm encountering the dreaded Error 1004 from the following line of code:

ActiveSheet.Cells(rngCurrRow.Row, colAccount).Value = ""

There are valid values in the parms for .Cells. This was working for a
long
time and now something has changed and I don't know what. I suspect
something
besides this actual line of code like some option or other factor. This
runs
fine on a different system.

I've turned off WS Protection, cell validation, Set General Format.

Any ideas? Thanks,
John S.