↓ Skip to Main Content
Useful code Programming with VBA, C# and Python

Main Navigation

  • All
  • VBA
    • VBA Tools
    • VBA Online Resources
    • All VBA articles
  • Python
  • Else
    • C#
  • Reviews
    • List of reviews
  • YouTube
  • PayPal
  • About
Useful code Programming with VBA, C# and Python

Off Canvas Menu

  • All
  • VBA
    • VBA Tools
    • VBA Online Resources
    • All VBA articles
  • Python
  • Else
    • C#
  • Reviews
    • List of reviews
  • YouTube
  • PayPal
  • About

Month: October 2017

Home › 2017 › October
C# – CodeForces – Borya’s Diagnosis
C Sharp Tricks

C# – CodeForces – Borya’s Diagnosis

Vitosh Oct 31, 2017 Tagged with Borya's Diagnosis, C#, codeforces

Every time, wherever I decide to take a look at CodeForces and to code & publish some of the easy problems, I am thinking that this is probably the last one, because it is too easy. However, I always find …

C# – CodeForces – Borya’s Diagnosis Read more →

VBA Excel – How to convert range to array easily
VBA \ Excel

VBA Excel – How to convert range to array easily

Vitosh Oct 27, 2017 Tagged with array, Excel, range, transpose, VBA

Converting a range to array makes a lot of sense in VBA, when some operations should be performed with data in a given range. The time saving is quite noticeable and it is a bit easier to access and modify …

VBA Excel – How to convert range to array easily Read more →

VBA – RegEx in Excel
VBA \ Excel

VBA – RegEx in Excel

Vitosh Oct 20, 2017 Tagged with email verification, Excel, regex, VBA

There is a well-known joke in the IT world – if you have a problem and you try RegEx to solve it, now you have two problems. Still, RegEx in VBA (and thus in Excel) exists as an additional library. …

VBA – RegEx in Excel Read more →

VBA – Change Conditional Compilation Arguments in Access
VBA \ Excel

VBA – Change Conditional Compilation Arguments in Access

Vitosh Oct 9, 2017 Tagged with access, Conditional Compilation Arguments, VBA

VBA is not a scripting language. It compiles. As such, it has compilation arguments, which can be changed through code or manually. In MS Access you may find these here: VBEditor>Tools>VBA Project>Database Properties: If you want to use them for …

VBA – Change Conditional Compilation Arguments in Access Read more →

C# – SoftUni – Natural Order Sequences
C Sharp Tricks

C# – SoftUni – Natural Order Sequences

Vitosh Oct 4, 2017 Tagged with algorithm, C#, Natural order sequences, recursion

Another SoftUni algorithm problem that I have considered interesting is presented here: You are given an integer S. Generate all non-empty sequences of numbers in range [1…S], which have sum of elements ≤ S. Display the sequences in their natural order, …

C# – SoftUni – Natural Order Sequences Read more →

Copyright © 2026 VitoshAcademy