Dreaded Runtime Error 1004.

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.
 
P

Peter T

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

UDF interaction with other macro causes Error 1004 6
Runtime error 1004 3
debug runtime error 1004 2
runtime error 1004 3
Copy/Paste Problem: Runtime error 1004 5
Graph - Runtime Error 1004 5
1004 runtime error 1
Error 1004 : function returning a Worksheet 2

Top