Fully Functional Dynamic Calendar Control in VBA
Ah, The complexities of automation! The versatile and multifaceted world of Excel VBA offers an array of tools and functionalities to streamline tasks and make life easier. Yet, despite its
Tag: Excel VBA
Data Consolidation: Allow User to select files on Runtime
In this article, we will explain to you the Data Consolidation from multiple Excel files using Application.GetOpenFileName in VBA. You can easily allow the user to select multiple excel files
User Defined Function for Sub-strings count from Excel Cell
We often need the count of sub-strings from out text available in Excel. For example we have comma separated ticket number in a cell and we have to count how
Text Join Formula for all Excel Versions
TEXTJOIN Function was introduced with the release of Excel 2016. This is very helpful function to join the multiple Text Join Formula for all Excel Versions into one. The best