Should there be an inspection for when annotation's aren't the topmost item? IE above Option Explicit. This could lead to edge cases where the declarations touches the first Sub/Function and the annotation is no longer considered part of the declaration.

I have an Excel spreadsheet with 1000 rows. Each row contains a customer name in column 1 then in column 2-13 is even amount. I need to create a new spreadsheet that has only 3 columns...Customer...Month...Amount. The kicker is that if the month is blank it needs to be ignored unless there is an...

> @MDoerner A few days ago I commited some code to #3534 dealing with things discussed here. Could you take a look at it? I would like to get some feedback before I start writing unit tests for all of this.

there is no <Import Project="..\packages\LibGit2Sharp.NativeBinaries.1.0.185\build\LibGit2Sharp.NativeBinaries.props" Condition="Exists('..\packages\LibGit2Sharp.NativeBinaries.1.0.185\build\LibGit2Sharp.NativeBinaries.props')" /> as it exists on retail.coder csproj for example

and SourceControl/Packages.config also doesn't have the nativebinaries installed (?)

actually following his stacktrace... C:\projects\rubberduck\RetailCoder.VBE\UI\SourceControl\SourceControlViewViewModel.cs:line 640; And later C:\projects\libgit2sharp\LibGit2Sharp\Core\Proxy.cs:line 2477 Is he running on his own libgit version on his own folder...?

when I started learning C++, a very recurrent mantra on C++ books was, and still is even for the most advanced ones: Be const-correct, my friend

in C++, const is part of a type (sort of), and a function that takes as a parameter a const Type won't compile if you send it a variable that is of type T but not const T (again, this shit was complicated as hell)

I'm even having sore-eyes when I don't read my consts all over the place on C#

My code generates 4 PowerPoint files from an excel document where I've aggregated data from my main file. One by one, it cuts and pastes a section of the excel sheet onto an individual slide, replaces some filler words with the appropriate date, saves and closes.
My code works, however it SOMETI...

Hey, since this morning I'm still wondering anyway. libgit2sharp native binaries are not referenced on the Rubberduck.SourceControl project in any way, so how could that even work for us if libgit2sharp has a dependency on these binaries?

> Nobody is going to read this anyway, and there would be so much to say about these 1.3K commits, ...so instead of putting you to sleep with a wall of text, I'll simply say - download the thing, try it, see for yourself.

> IIUC what this issue suggests is that Rubberduck Hotkeys with `Ctrl + Shift` should not trigger in User Form design mode, since the designer already uses that key-combination to select Properties based on their name.

I have a class module with the method Create. That method has Dim tableData As Object followed by Set tableData = GetWorksheetCodenameAndNameData(inputCell.Parent, delimiter). The function that it calls has the signature of Private Function GetWorksheetCodenameAndNameData(ByVal chosenWorkbook As Workbook, ByVal delimiter As String) As Object.