GitHub

A library with many useful functions for assisting on EXCEL VBA coding

'=====' '----- Utilities Functions ...
LinkedIn

Working with Strings in Excel VBA

Howdee! If you’ve ever written any VBA code, you’ve likely had to edit strings in Excel VBA. It can be challenging and more than a little frustrating, especially if you’re not familiar with the tools ...
GitHub

Excel-VBA-Diary/Regular-Expression-Functions

Microsoft Excelの正規表現関数（REGEXTEST、REGEXREPLACE、REGEXEXTRACT）は、2024年5月にリリースされました。これらの関数は、Excelの365 Insiderプレビュー版で最初に導入されましたが、現在は一般公開されています。 これらの正規表現関数は、Microsoft 365の ...
LinkedIn

VBA Basics - Sub Procedures Vs Functions

This article describes the differences between sub procedures and functions within VBA (VBA being ‘Visual Basic for Applications’ – the programming language used to write macros within Microsoft ...