Run-Time error '1004'

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
 
H

hansjhamm

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
 
D

Dave Peterson

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

hansjhamm

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
 
Top