Closed

Hire an Excel Expert

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.

Skills: Excel

See more: excel programmers for hire, excel experts forum, excel freelancers, excel experts online help, excel expert jobs, excel expert tutorial, excel expert salary, excel expert online chat, how to hire excel expert, hire excel expert tel aviv, hire excel expert for 2 hours, excel expert for hire melbourne, excel expert for hire las vegas, excel expert for hire in delhi, excel expert for hire

About the Employer:
( 30 reviews ) Vancouver, Canada

Project ID: #15212448

14 freelancers are bidding on average $34 for this job

jaylancer43

Expert Excel Programmer on [url removed, login to view] and have been featured by the freelancer community ([url removed, login to view]) Relevant Skills and Experience I am an E More

$30 USD in 0 days
(492 Reviews)
8.0
schoudhary1553

Hello Sir, I am the expert freelancer for this job . i have deliver more than 250 projects with 100% client satisfaction. so please give me chance to work on your job. Relevant Skills and Experience I have more than More

$70 USD in 1 day
(184 Reviews)
7.0
HardWorker1989

Hi there. Just a question. Have you ever used PDF Forms before? They are very versatile and can perform more complex calculations then these Excel sheets. Kindly send me a message to have a look. Relevant Skills and More

$30 USD in 1 day
(69 Reviews)
6.8
renesontiongson

Pleasure to help you. Excel automaton is my masterpiece in my accounting field. Feel free to message me to start the job. Thank you so much. Relevant Skills and Experience Excel automation, macros, accounting Prop More

$25 USD in 1 day
(47 Reviews)
5.0
narsim3128

With respect to this project I would like to present myself as a candidate for your consideration. I have more than 8 years of IT experience. I have successfully completed few projects for US clients Relevant Skills a More

$66 USD in 2 days
(29 Reviews)
4.6
anzarulislam

Hi.. I am interested to your project . I believe that I'll do this work properly and in timely . I am agree with your budget. And I'm sure that I'll finish the task with your full satisfaction . Lets start More

$30 USD in 1 day
(4 Reviews)
3.5
$25 USD in 1 day
(9 Reviews)
3.7
dayakmlt

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

$30 USD in 2 days
(12 Reviews)
3.2
aubrey03

A proposal has not yet been provided

$30 USD in 1 day
(6 Reviews)
2.7
chintuag

I have read the project description and understand that you are getting errors for "Subscript Out of Range" and "Run Time error-1004" while running a macro. Relevant Skills and Experience I will fix the issue as I am More

$28 USD in 2 days
(1 Review)
2.7
bondilimahesh

A proposal has not yet been provided

$30 USD in 1 day
(1 Review)
1.8
haleem0786

I can do this. do let me know more detail in PM

$27 USD in 1 day
(1 Review)
1.2
syasuliman

y) chance to make a good first impression to the employer! Ensure that you: Understand their project needs. Explain how your skills and experience make you the right freelancer for the job. Outline how you plan t More

$25 USD in 1 day
(0 Reviews)
0.0
brobb07

Excel expert with extensive vba experience. I can help you fix you rmacro. I work in macros everyday. Relevant Skills and Experience I have worked for several years in excel and perform daily work using vba, user fo More

$30 USD in 1 day
(0 Reviews)
0.0