Dreaded Runtime Error 1004.

  • Thread starter Thread starter DocBrown
  • Start date Start date
D

DocBrown

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.
 
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
 
Back
Top