How to resolve Run-time Error '1004':Method 'Range' of Object_Worksheet' failed

Question

How to resolve Run-time Error '1004':Method 'Range' of Object_Worksheet' failed

Xin Yuan Lee 0

Screenshot 2024-02-16 at 11.49.09 AM

I am trying to create an automated invoice that can save and update the details by using VBA code but i got the error "Run-time Error '1004':Method 'Range' of Object_Worksheet' failed" on this code:
Invlist.Cells(InvRow, InvCol).Value = .Range(Invlist.Cells(1, InvCol).Value).Value 'Save Invoice List Data

My full code is in the picture above Does anyone knows how to solve the error? Thank you

Barry Schwarz 3,746 Reputation points

2024-02-16T08:32:56.0866667+00:00

Step through the code in the debugger. When the error occurs, click on Help. In the immediate window, print out items of interest such as the value of InvCol, the address of Invlist, the address of Invlist.Cells(1,InvCol), the value of same, etc. Keep working from the innermost values outward until you find the anomaly. Show us these values if you are still stuck.

Your answer

Barry Schwarz 3,746 Reputation points

2024-02-16T08:32:56.0866667+00:00

Step through the code in the debugger. When the error occurs, click on Help. In the immediate window, print out items of interest such as the value of InvCol, the address of Invlist, the address of Invlist.Cells(1,InvCol), the value of same, etc. Keep working from the innermost values outward until you find the anomaly. Show us these values if you are still stuck.

Share via

How to resolve Run-time Error '1004':Method 'Range' of Object_Worksheet' failed

Your answer