Hello Experts,
I need your help with the attached excel macro enabled file
As soon as I click on "Run", a debug message appears. I would appreciate it if you could resolve this debugging issue. (Attached image)
I look forward to receiving a favorable response from you.
Thank you..
So z is a collection and the line of code it's bugged on is trying to access an element in that collection. Elements are identified by number and you have Cstr in there, which is converting to a string. Can trying changing that cstr to cint.
Thanks for your comments,
It has been changed in accordance with your instructions, but the result remains the same. (debug)
Should I change any settings in the VBA module or choose any references from the library to avoid the Run_time errror 5 ?
Last edited by ans1718; 12-16-2022 at 02:53 AM.
I would suggest you take out the On Error Resume Next and see what other errors you get.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Thanks for your reply, getting mismatch error then, could u check the attached excel file with codes?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks