make a change to VBA code in an excel spreadsheet
$10-30 AUD
货到付款
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
项目ID: #25746229
关于项目
授予:
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.
有13名威客正在参与此工作的竞标,均价$25/小时
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.
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 更多
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 更多
$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 更多
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 更多
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 更多
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 更多
hii Sir I have read your project details I can do it I have done many same projects. yes I can do it again.
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 更多