Run-Time error '1004'

  • Thread starter Thread starter hansjhamm
  • Start date Start date
H

hansjhamm

What in the world is this?? While I was working on my project, I would
run the code to ensure it was correct. Saved it last night, opened it
up this morning added additional sections of code and it ran fine. Then
completed the project saved it this morning, tried to re-run...AND got
this message; "Run-time error '1004' Application-defined or
object-defined error"

What in the world has happened here? And how do I go about the
correction?


Thanks,

Hans
 
I will now reply to my own post...I found the problem! Also, did not
know this one! I had the code written on the sheet and not in a module,
so I could not see where the errror was at, once I cut and pasted it
into a module I could debug it...Does anyoone out there know why this
happens???

Thanks

Hans
 
Unqualified objects in a sheet module belong to that sheet. This is different
behavior than what you'll see in a General module.
 
Dave,

Yeah I found that one out there hard way didn't I? It really had me
perplexed...I do appreciate the "why"!

Take care,

Hans
 

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

Run-time Error '1004' 1
Run time error message???....Help!! 12
Application.Goto Reference gets error 1004 4
Run time error 1004 When running in 2003 10
Run time error 1004 in loop 4
Run-time error '1004': 1
Run-time error '1004' 8
Excel Excel VBA (Saving as A CSV) 1

Back
Top