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...
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...
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...
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...
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...
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...
SQL like with asterisk * works in MS-Access Query but not in VBA ADODB
I recently encountered a problem while writing a query for an excel application where I use ADODB to retrieve a list of items from the...
Stop computer from locking windows and keep status Active on Skype / Teams / Jabber using VBA scrip
With the pandemic pushing almost everyone to work from home and most of us are required to stay active on collaboration tools even if...
TEST YOUR EXCEL SKILLS IN EXCEL
So you want to know how good you are in excel then make sure you download our test now. Its not a multiple choice question style test but...
FREE SQL TRAINING FOR HYDERABAD STUDENTS
Hi All- There has been a request from most of the students attending excel and VBA classes to show what SQL queries are and how SQL can...
