VBA Macro Debugging

The attached file contains a code to fill the web form, where a user form appears and auto fills the value, then I need to fill the Captcha manually and submit whereon the copied on to the excel sheet in the specified columns. But I am having a trouble in running the code. I would appreciate if anyone can debug the same.
Auto-Fetch-EEE-5.xlsm
Kanwal_No2Asked:
Who is Participating?
 
Martin LissOlder than dirtCommented:
It also looks like
If Len(Trim(Range("ListPN").Value)) = 0 Then

should be

If Len(Trim(Range(strAdd).Text)) = 0 Then
0
 
Martin LissOlder than dirtCommented:
I believe it should be strAdd = Range("ListPN").Address rather than strAdd = Range("ListPN") but you have more problems following that.
0
 
Kanwal_No2Author Commented:
I did that but it seems further issues looms large. Do have a Look. I tried to correct it but my VBA is in quite inadequate. The solution also was given here only.
Auto-Fetch-EEE-5.xlsm
0
 
Martin LissOlder than dirtCommented:
Since I've already apparently answered more than your original question, please create a new question for the rest and I'll be happy to help.
0
 
Kanwal_No2Author Commented:
Yeah Sure. Please Check for the next question.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.