About two years after the “Nested loops with recursion” today I was looking for a way to avoid nested loops with recursion in google and found my article 🙂 . Lots has changed in my coding style since then as …
VBA – Avoid nested loops with recursion (Part 2) Read more »
The formulas in Excel, used through VBA are not easy. You need to write a string like “=IFERROR(OR((1=A1),(2=A2)),””No Error””,””Error””)” and this is really not easy and fun to debug. Furthermore, if it is false, VBA will nicely throw a runtime …
This month I have passed Exam 70-462: Administering Microsoft SQL Server. Thus, officially I am a MCSA in SQL Server 2012/2014. Concerning the exam – it is tough! In order to pass it I have studied for about 6 months. The …
Trimming is a function, that reduces spaces. There are at least 4 ways to Trim a string in Excel/VBA: Trim VBA.Trim =Trim() WorksheetFunction.Trim Thus, is there a difference between these 4 actually? This is what MSDN says about String.Trim: Returns …
VBA – Difference between Trim, VBA.Trim, =Trim() and WorksheetFunction.Trim Read more »
Imagine that you want to check when is Friday for the week of Christmas in the next 10 years. In general, the week of Christmas is the week that contains the 25.December. Getting a given day from a given week …
VBA – What day is Friday in the week of a given date? Read more »
Using Visual Studio and Excel is actually quite fun – the Visual Studio advanced environment provides a bit more possibilities than the Visual Basic Editor, built-in Excel. In this article, about a year ago I have shown how to loop …
C# – Looking for a value in Excel with C# & VisualStudio Read more »