Hi everyone,
I downloaded the Template for the Invoice & Tracker file from the video posted on Wed 7 May, 2025 https://youtu.be/i-9ugC2sjGc?si=i7mg512AcjNAxwcs . I also followed the tutorial and created a separate one but the issue seems to be occurring in both. The recording of the invoice along with the creation of an entry in the tracker works fine but when it is time to clear the invoice that is where the problem arises.
I have attached both a screenshot and the file which I created.
If you look at the "'Clear Cells" part of the ResetInvoice() section it looks almost exactly like the code in the original but I am getting that run-time error. I have double and triple checked to see where I am going wrong but I seem to be missing it.
I am running this on Windows10 fully updated. (I don't know if that makes a difference regarding tracking down the issue)
Any assistance with this matter would be appreciated.
The table in your invoice is called InvoiceItems. In the VBA code for clearing the invoice, it's referred to as InvItems.
You need to change one of them so they both match.
@mynda Thank You soo much. I looked at it sooo many times and I didn't even notice that. It has resolved the issue.
