make a change to VBA code in an excel spreadsheet

已完成 已发布的 3 年前 货到付款
已完成 货到付款

I have created a spreadsheet that is protected and has the "ProtectedSpellCheck" VBA code. Also, it has code (provided) that allows for a multiple list (sheet 4 "Contacts and Other" Column "O").

However, when I run the Macro for the Spell Check it causes the multiple list macro to error with run time error'-2147024809 (80070057)' with the narrative "The specified value is out of range". The Multiple list Macro works fine when protection is off or when it has been switched on manually, but not when the Spell Check runs

Excel Visual Basic Visual Basic的应用程式 数据处理 软件构架

项目ID: #25746229

关于项目

13个方案 远程项目 活跃的3 年前

授予:

sacpatil0411

I have 5+ years of experience in excel, advanced excel, Excel VBA and Automation. I believe in delivering the projects in the provided timelines with optimum quality.

$25 AUD 在7天内
(0条评论)
0.0

有13名威客正在参与此工作的竞标,均价$25/小时

rinabuoy13

Hello, I am an independent, experienced excel / vba expert. I can help with this task with a quick turn-around. Looking to hearing from you. Kind regards Rina B.

$30AUD 在1天里
(156条评论)
6.6
finecodervw

Hi, I have gone through the attachment and help you to resolve the error. I was able to reproduce the error you mentioned. Please let me know when you would like me to start on this. Looking forward to working on th 更多

$25AUD 在1天里
(186条评论)
6.4
narsim3128

NOTE : I HAVE EXPERTISE IN VBA. I CAN FIX THIS ISSUE IN QUICK TIME With respect to this project I would like to present myself as a candidate for your consideration. I have more than 12 years of IT experience. I have 更多

$30AUD 在1天里
(50条评论)
5.8
AnowarRatul

$19 AUD Only ----- Dear sir, I have read your project details and reviewed the attachment carefully. I can make the VBA Macro Modification by maintaining 100% accuracy of your data absolutely as you want ------- Excel 更多

$19AUD 在1天里
(110条评论)
5.4
amwazeindia

Hello, I checked the attached sheet and the codes, but couldn't recreate the error code. Can you please be specific when this error popped up? From the error code, the issue could be in the usedrange , but need to recr 更多

$20AUD 在1天里
(10条评论)
5.0
sajjadtaghvaeifr

Hi, I have PhD in mechanical engineering from Tohoku University of Japan. I have published 20 Journal papers and 16 international conference papers. I have read your Requirement. My expertise match this job. Please sen 更多

$50 AUD 在7天内
(2条评论)
3.2
murugesan24

Hi, I tried you attached file, I couldn't reproduce the error which you have mentioned. Macro is running fine for me. If you can ping me and give more details, I can fix it for you. I would like you to check the review 更多

$30 AUD 在7天内
(4条评论)
2.5
mainumaldar

hii Sir I have read your project details I can do it I have done many same projects. yes I can do it again.

$10 AUD 在12天内
(0条评论)
0.0
Raykun

Hi There, I am interested in getting a job. And I am sure I will be able to complete the work according to your expectations. Because indeed it is my expertise for 1 year in offline work. Do not hesitate to entrust th 更多

$20 AUD 在7天内
(0条评论)
0.0
bhagwansingh786

I am a certified accountant and Data Entry expert. I strongly believe Top Quality and Client Satisfaction are the norms of the best selling. I will accurate and professional Data Entry at a very reasonable price. I wil 更多

$12AUD 在1天里
(0条评论)
0.0
anangsoen

Hi, I can help you with VBA modification.

$20 AUD 在7天内
(0条评论)
0.0