We are looking to hire an Excel expert who can help fix a macro program that is used for creating invoices.
Below are the problems that we experience while using the document:
When pressing the button "Get Invoice #/Finish", an error window shows up with "Run-time error 9 Subscript out of range" message.
According to the Debug, the error is under the FormatFormulas macro in the following line:
107 [url removed, login to view](1).DragOff Direction:=xlDown, RegionIndex:=1
When hitting F8 for debugging another error message appears: "Run-time error '1004': Application-defined or object-defined error"
Most of the times when clicking "Remove Last Item" button, the Search Product box stops working.
Also, when the list of files is cleared from Open Recently in Excel, the Invoice program works fine. After we want to get a second invoice, the error message appears.
The file is attached.
14 freelancers are bidding on average $34 for this job
File is working fine in my system Relevant Skills and Experience Excel Proposed Milestones $30 USD - Excel 1st line error comes when data is out of set range