VBA – Delete / Remove rows from a specific worksheet in Excel
Imagine one of the most trivial tasks in Excel – remove rows from Excel, for which …
VBA – Delete / Remove rows from a specific worksheet in Excel Read more →
Imagine one of the most trivial tasks in Excel – remove rows from Excel, for which …
VBA – Delete / Remove rows from a specific worksheet in Excel Read more →
The formulas in Excel, used through VBA are not easy. You need to write a string …
Trimming is a function, that reduces spaces. There are at least 4 ways to Trim a …
VBA – Difference between Trim, VBA.Trim, =Trim() and WorksheetFunction.Trim Read more →
Using Visual Studio and Excel is actually quite fun – the Visual Studio advanced environment provides …
C# – Looking for a value in Excel with C# & VisualStudio Read more →
After writing that the built-in Find() function in VBA does not return the first value by …
If you are coding professionally in VBA, most probably you are using arrays every now and …
VBA – ArrayList class – a helper to sort arrays in VBA Read more →
There is a lot over the Internet, written for the dates in Excel, VBA and SQL …
After the first part about RegEx in Excel lately I had to do something else with RegEx. …
Converting a range to array makes a lot of sense in VBA, when some operations should …
VBA Excel – How to convert range to array easily Read more →
There is a well-known joke in the IT world – if you have a problem and …