In this post I present the best practices to find in Excel VBA the Last row, last column of a worksheet and Type Name of the current selection. See here how to do it properly
DetailsIn this article I present a model for monitoring the time spent at office by employees, check-ins and check-outs. I used Excel array formulas (max, min, small) with multiple conditions and also other formulas.
DetailsIn this post I present 5 examples of C# simple exercises with strings. Try to solve them by yourself and if you miss something, you have also one possible solution.
DetailsThe part 2 of the post which shows how to create a simple application with Windows Forms interface and SQL Server Database
DetailsThis post explains how you can automatically install and activate an Excel Addin using VBA code. At the end you can also download the installation file.
Details
