VBA for Excel throws "Object variable or with block variable not set ...

I have tried making the datatype of my variables to Long, but with no ... are not objects, so doing that throws the "Object required" compile error.

stackoverflow.com