error -2147417848

I receive everyday reports with tables in outlook, I want to create a macro that can copy the table in a new excel file and save it to a folder in my desktop, I have this code that it is working with small tables, 100 or 200 rows, but it fails with bigger tables with 2000 rows or more, the error...

I use this VBA in a macro. Excel2016.: Option Explicit Sub LastRowWithData() Dim lastRow As Long lastRow = ActiveSheet.Range("E" & Rows.Count).End(xlUp).Row Range("Control!B2") = lastRow Range("J1") = lastRow End Sub The debugger indicates that the red highlighted row is the problem. I can't...

Hi, I've got the following vba code that looks up a vendor name based on a user entered vendor number. If the vendor number doesn't exist a msgbox pops up, and the userform should unload and dissapear. But I get a run time error that I can't figure out why and I've searched everywhere for what...

My environment is XP running office 2007. I am developing an excel application using VBA forms. everything works fine, no errors, until I protect the VBA project. When I protect it, I close and save the workbook and then re-open it. Many times it works the first time I open it and fails on the...