Hire an Excel Expert

Ditutup Dipasang 6 tahun yang lalu Dibayar saat pengiriman
Ditutup Dibayar saat pengiriman

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.

Excel

ID Proyek: #15212448

Tentang proyek

14 proposal Proyek online Aktif 6 tahun yang lalu

14 freelancer rata-rata menawar $34 untuk pekerjaan ini

jaylancer43

Expert Excel Programmer on freelancer.com and have been featured by the freelancer community (https://www.freelancer.com/community/articles/jay-patkar-freelancer-success-story) Relevant Skills and Experience I am an E Lebih banyak

$30 USD dalam 0 hari
(492 Ulasan)
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 Lebih banyak

$70 USD dalam 1 hari
(184 Ulasan)
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 Lebih banyak

$30 USD dalam 1 hari
(69 Ulasan)
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 Lebih banyak

$25 USD dalam 1 hari
(47 Ulasan)
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 Lebih banyak

$66 USD dalam 2 hari
(29 Ulasan)
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 Lebih banyak

$30 USD dalam 1 hari
(4 Ulasan)
3.5
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 dalam 2 hari
(12 Ulasan)
3.2
aubrey03

A proposal has not yet been provided

$30 USD dalam 1 hari
(6 Ulasan)
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 Lebih banyak

$28 USD dalam 2 hari
(1 Ulasan)
2.7
bondilimahesh

A proposal has not yet been provided

$30 USD dalam 1 hari
(1 Ulasan)
1.8
haleem0786

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

$27 USD dalam 1 hari
(1 Ulasan)
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 Lebih banyak

$25 USD dalam 1 hari
(0 Ulasan)
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 Lebih banyak

$30 USD dalam 1 hari
(0 Ulasan)
0.0