Forum Discussion
Error is: Compile error: Method or data member not found after EXCEL upgrade to v. 2019
Dear members, We had working VBA code copying some data from Outlook mail to Excel file. It worked without problems until Excel version was upgraded to Excel 365/2019. Error is: Compile error...
Try this and see if that works for you...
newRowIndex = ws.Range("A" & ws.Rows.Count).End(3)(2).Row