> **Rubberduck version information** Version 2.5.1.5557 OS: Microsoft Windows NT 10.0.14393.0, x64 Host Product: Microsoft Outlook x86 Host Version: 16.0.4266.1001 Host Executable: OUTLOOK.EXE
**Description** The event procedures _Itemadd on some collections are marked as "Procedure not used"
**To Reproduce** declare ``` Private WithEvents colCeka As Items Private WithEvents colDrafts As Items Private WithEvents colInbox As Items Private WithEvents colStavyZaruk As Items ```
> Could you check whether renaming to colDrafts_ItemAdd fixes the false-positive? I have a sneaking suspicion that the casing of the event that's handled is relevant here.
> Yes, that's true, it is case relevant. Everything except "ItemAdd" throws the "procedure not used. I have checked the combination of "itemadd", "itemAdd", and "Itemadd".
> Okay, the root cause for that is the code we use to find event handlers, located in the DeclarationFinder. It compares for exact matches of the event name:
I have this code that:
Clears my worksheet from row 12 and onward in Workbook A
Opens a new file Workbook B
Copys the sheet to my Workbook A. and Close Workbook B
Renames sheet in Workbook A
Transfers data from New Sheet to another Tab.
This seems to take me 5 minutes+, it is roughly 35k Rows.
...
Background:
I have close to 50 excel files - I cannot change the data source - and I steadily get more.
My task is to make sense of all that data and, lo an behold, save that as another excel file (I asked if I should put it in a local database, but no, I should not).
Asking on SO lead me here, a...
I have this code that:
Clears my worksheet from row 12 and onward in Workbook A
Opens a new file Workbook B
Copys the sheet to my Workbook A. and Close Workbook B
Renames sheet in Workbook A
Transfers data from New Sheet to another Tab.
This seems to take me 5 minutes+, it is roughly 35k Rows.
...
VBA Rubberducking
VBA Rubberducking