Suljettu

Fix Excel VBA macro

I have a few buttons on a custom made ribbon which are producing errors. The errors seems to relate back to a single sub which needs to be fixed.

I have 3 files where this is a problem, so I will need guidance on how to fix the issue.

I imagine this is a very small project that is easily fixed. I have uploaded two screenshots of the errors I am encountering.

Needs to be fixed today.

Taidot: Excel, Visual Basic for Apps

Näytä lisää: allocation macro vba excel, excel 2003 small project, small project macro vba, small project vba excel, excel vba small project, small vba excel project, macro vba excel example, macro importing excel project, update vba excel project

About the Employer:
( 23 reviews ) Knottingley, United Kingdom

Projektin tunnus: #13090954

50 freelanceria on tarjonnut keskimäärin 19 £ tähän työhön

cgullapalli

Hi, I am good at Excel and building useful scripts for my clients. I have seen the problems. It is range and work sheet selection error. I can easily fix this. I just checked the description you have provided reg Lisää

12 £ GBP 0 päivässä
(356 arvostelua)
7.2
deepbluetech

Hi, I need to have a look at the complete code. Please share the xla file and confirm Excel version in use. Regards, Arul

20 £ GBP 1 päivässä
(191 arvostelua)
7.1
SBITServices

Hello SIMONKIWI, I have checked the screenshots and it is very simple to fix. Just needs to change 2 lines code. I agree that can complete task with high quality and consistency.Check our reviews to confirm our wor Lisää

10 £ GBP 1 päivässä
(126 arvostelua)
6.5
18 £ GBP 0 päivässä
(205 arvostelua)
6.1
dpune

Hi, I have more than 14 years of Excel/VBA exp and I am expert in this kind of work. Let us discuss more details so that I can estimate cost and time better. I have completed more than 300 projects. Plea Lisää

20 £ GBP 1 päivässä
(103 arvostelua)
6.1
paris2785

Hi there - My name is Paris. I've read your brief and can see that you'd like to have a macro-enabled (VBA) Excel spreadsheet. I have 7 years’ experience designing and developing Excel spreadsheets. I would approach y Lisää

18 £ GBP 1 päivässä
(96 arvostelua)
6.1
schoudhary1553

Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. Here is the reason. Why you should pick me? a) I am a very expert and have the same kind of ex Lisää

23 £ GBP 0 päivässä
(106 arvostelua)
6.1
TonmoyRoy111

Dear client, I have sound knowledge in Excel and I have previously carried out a number of projects in excel using macros and formulas. I ensure you will be happy after hiring me. Kindly contact me for further detail Lisää

20 £ GBP 1 päivässä
(138 arvostelua)
5.7
nagybatonyi

Hi, I have a university degree in economics and IT, and several decades of system design and programming, in the recent decade especially in Excel and VBA. In my approach you'll have opportunity to consult details Lisää

13 £ GBP 0 päivässä
(59 arvostelua)
5.7
parsermonster

Hello, Have you tried to export the project modules and re-import them? If so and that did not work, then I'll have to trace the range error. Usually, export-reimport works if the ribbon was previously working fi Lisää

15 £ GBP 0 päivässä
(15 arvostelua)
4.9
abdolah2014

HI I am an excel-vba Expert and I can fix it so fast test this one if FrontSection is a worksheet in your excel :) set rng = Worksheets("FrontSection.Range("NVQProgressPer") bye

10 £ GBP 1 päivässä
(31 arvostelua)
5.1
ksriniravi

Greetings! I have 17+ years experience in using Excel as part of my daily work life. In the process I have implemented lot of automation / modelling as well as dashboards for Management Reporting. In fact, over the Lisää

20 £ GBP 1 päivässä
(45 arvostelua)
5.2
royalcalif

Hi Mr. Employer I have lot of experience in excel spreadsheet and I can do this project in effective manner with 100% accuracy report to your requirements. See Below video as my earlier work with Excel . Recipes Mana Lisää

10 £ GBP 1 päivässä
(18 arvostelua)
4.1
10 £ GBP 1 päivässä
(14 arvostelua)
4.0
magentapowa

Hello I have major experience working on VBA and believe I can help you. From the images it is not clear what the problem is, I will need to see how "FrontSection" is defined. I will need to look at the whole file. Lisää

20 £ GBP 1 päivässä
(18 arvostelua)
3.6
jhony1981

I am an expert in excel macros having more than 10 years of experience, Please consider me for the job,. Looking forward to hear from you soon.

13 £ GBP 1 päivässä
(9 arvostelua)
3.4
BadihBarakat

Hi, Let me have a copy of the excel file and I will fix the issue for you. The provided images tells little about the problem but do not provide enough information. I'll take care of it for you. :)

18 £ GBP 1 päivässä
(2 arvostelua)
2.9
rameshmahala

Hello there, I would like to be considered for this job as I have great working experience in macro writing and debugging. Right now, I am at my regular job and will start it once I go home, after 2 hours. Thanks, R Lisää

16 £ GBP 1 päivässä
(4 arvostelua)
2.8
ma7oda

Hello, i have 8 years experience in excel macros for automation and web scraping. if you can share the macro to asset the work and give you accurate time to finish. Thanks

23 £ GBP 1 päivässä
(3 arvostelua)
2.0
draco77

Hey there, From the sounds of it, you need an Excel expert who can write VBA code to fix you workbooks. Is that sounds about right? I have an extensive knowledge of Excel included VBA. I have also a strong database Lisää

10 £ GBP 10 päivässä
(5 arvostelua)
2.2