The Range.Find() function in VBA-Excel is quite a tricky one. In general, you may think it is straight forward, because it usually returns what you are looking for, until the moment when it simply surprises you. This is the MSDN description…
Month: December 2017
VBA – Type Declaration Suffixes
If you are coming from the .Net world, then you are used to declare variables like this:
|
1 |
Dim foo, bar as Long |
In this case, both foo and bar are of type Long. Then, someone tells you that you want to switch for a…
VBA – Attributes. The high-end in VBA.
You have probably noticed, that whenever you export a class module from the Visual Basic Editor, you get some strange lines in the exported file, above the Option Explicit. This is something, that you have not written, but it is…
C# – CodeForces – Chtholly’s request
Solving problems at CodeForces is a kind of hobby. Lately, in round 449, division 2, there was a problem which has met my interest. It has to do with palindromes and really big numbers. The problem is easy to calculate,…
VBA – RegEx in Excel – Part 2
After the first part about RegEx in Excel lately I had to do something else with RegEx. The task was quite simple, pretty much called “stripping a string”. The idea is that you have a string and you should remove all…
Top