May 28, 2019 | Excel, VBA
If one day your manager hand you an Excel file and ask you can you create worksheets for each of the company list in a column, and you see that there are approximately 100 items. And image if you have to create them one by one for a 100 times, that must be a super...
May 21, 2019 | Access, Excel, Office Automation, Outlook, PowerPoint, VBA, Word
For various reasons, you want to calculate how long does it take for a macro to run from start to finish. Using few lines of simple VBA, we can quickly figure out how long does it take for a macro to execute. data-ad-layout="in-article" data-ad-format="fluid"...
May 20, 2019 | Excel, VBA
In general when we write VBA scripts we either trying to automate an office application task like in Excel, Outlook, Word, or Access, or we are trying to implement a functionality to an existing program. One thing makes VBA versatile is its ability to work with...
May 11, 2019 | Excel, VBA
Knowing how to perform a lookup task is important and critical in Excel. Majority of the spreadsheets out there probably have some sort of lookup formula embedded. Perform a Vlookup task is pretty easy on the Excel UI, you simply use the VLOOKUP (or INDEX/MATCH)...
