Challenge - Excel Challenge #903 (How to use double quotes in a formula in a VBA code)
To insert a formula in a range you can use the range.formula command in VBA. Like for example you want to add the columnA +columnB values...
0 comments

Challenge - VBA Challenge #902 (Count the ending zeroes after a number)
Here is the situation, check the below numbers in the picture. The task is to count the number of zeroes at the end after any number. Put...
0 comments
Create separate workbook from worksheets VBA
Split worksheets into separate files Macro to create multiple workbooks from a master worksheet Recently as part of a consulting...
0 comments
WHAT TO BACKUP WHEN CHANGING LAPTOP
I have changed around 5-6 laptops in the last 10 years, I know that's not good but I have to due to various reasons, sometimes to get a...
0 comments
Challenge - VBA Challenge #901 (Find if the number is even)
Starting a series of challenges on VBA. Will extend this to SQL, Excel, Power BI, Tableau. Feel free to drop in a solution in the...
0 comments


Auto Email Drafter - Mail Merge Outlook
You love mail merge but I am sure that once in a blue moon when you have to do it you will have to google it and see how to create...
0 comments