Run-time error '424' (object required)

Hello

The 424 error occurs when an object is necessary.
I’m having trouble to reference an instruction to a property of an object.
The object in question was created in a form and the instruction that needs it belongs to a class of functions.
I tried starting and restarting and create a new object in the function, but I got the error 91 (Object variable or with block variable not set).

Question: How do I refer the instruction to the object property already created?
Data:
The instruction belongs to Excel.Application.

I’m using VB6.

this snippet of code belongs to the form:
-----------------------------------------

Please Login or Register  to view this content.

------------------------------------------------------------
this snippet of code function:
-----------------------------------------------------------

Please Login or Register  to view this content.

----------------------------------------------------------
the instruction Selection.Copy that referenced to the object xl

jovir,

Welcome to the forum.

I have added code tags to your post. As per forum rule 3, you need to use them whenever you put any code in your post. Please add them in future. If you need more information on how to use them, check my signature below this post.