I am using Office 365 and I got Invalid use of Null at this line MsgBox lastPage.Length
YasserKhalil Well-Known Member Nov 21, 2021 #51 I am using Office 365 and I got Invalid use of Null at this line Code: MsgBox lastPage.Length
shahin Active Member Nov 21, 2021 #52 Please try now. This time you should get some tabular content before running into that Null type error. Attachments testLastPage.xlsm 30.8 KB Views: 4
Please try now. This time you should get some tabular content before running into that Null type error.
YasserKhalil Well-Known Member Nov 21, 2021 #53 Yes, you are right. I could get some tabular content before getting the error
shahin Active Member Nov 21, 2021 #54 Following your suggestion I seem to have fixed it. Just let me know for the last time if it works on your end. Thanks a trillion for your great support. Attachments ramaJudicialModified.xlsm 36.5 KB Views: 4
Following your suggestion I seem to have fixed it. Just let me know for the last time if it works on your end. Thanks a trillion for your great support.
YasserKhalil Well-Known Member Nov 21, 2021 #55 Now I got Object doesn't support this method or property at this line Code: contactLink = sBase & Replace(contactLink.getAttribute("href"), "about:", "")
Now I got Object doesn't support this method or property at this line Code: contactLink = sBase & Replace(contactLink.getAttribute("href"), "about:", "")
shahin Active Member Nov 21, 2021 #56 Is it still complaining? Or you see links in two message boxes? Attachments ramaJudicialModified.xlsm 36.9 KB Views: 1
YasserKhalil Well-Known Member Nov 21, 2021 #57 It is working partially till the lawyer id 14785 MsgBox contactLink.getAttribute("href")