Is PUBG getting banned in India? Recently, many of the internet users came across a letter stating that PlayerUnknown’s Battleground, popularly known as PUBG, is getting banned in India. This news spread very quickly in the social networks with many people sharing and retweeting it with their friends. But, a… [Continue Reading]
Fortnite Game Fortnite is a popular online video game, which comes with a couple of game modes to play. One of the modes-Fortnite: Battle Royale is a completely free game mode in which 100 online players fight-off against each other, with the last person alive winning the game. You can… [Continue Reading]
Excel – Enable Disable Commands & Options There are about 150+ options available with the code presented in this section. The notable options are “Status Bar” and the Popup menu that appears when you right click on a cell or row etc., Using this code, those options can be switched… [Continue Reading]
Browse File Dialog in Excel VBA In Excel file, if you are doing any folder operations or trying to read content from another text,xlsx, csv file. It is better to use this file dialog box rather than manually typing the file name with path. It would reduce the typing errors… [Continue Reading]
Get Excel VBA code to copy worksheet from one workbook to anotherworkbook. Also, after copying the sheet, you can rename or access it with a new object and it is easy to use this way.
Speed up Excel macro using these optimization technique. Using this the Excel VBA macro run time is reduced making it more faster than before.
Get the command to convert a number to string. Convert variable of data type integer/float/double to a string value, so that the assignment or IF works.
Is Option Explciit not working in your code as desired. Undeclared variables are not reported. Here is the fix to make Option Explicit to work as desired.
Get VBA code to delete file from a system folder. It uses filesystemobject.deletefile function & the VBA.kill function. Both uses the filepath as parameter.
Get Excel VBA code to list all the defined names in the workbook. This code will also get the formula, comments, value along with the defined name.
- Block Apps in FaceBook print screen Excel Countif Record Macro Timer in Excel Task Manager VCF HTML Table Import Data Thumbnails Text to Speech TTS Candy Crush C++ Programing Machine learning AI bulk email Excel VBA vba color index vba color codes Android social media Twitter Google+ Google Adsense Tips bitcoin Calendar in Excel outlook vba mass email Data Mining Excel Macro Facebook WhatsApp Wordpress python