1. Check if AutoFilter is On or Off in any Worksheet This below vba function returns True if autofilter is enabled in a worksheet. otherwise returns false. Note that we can have only one Autofitler for each worksheet. Check if Autofilter is Enabled in Activesheet Instead of checking for any… [Continue Reading]
Enable Grayed Option on Excel Right Click Does some of the options on the right click command bar is disabled or grayed out in your Excel Worksheets. Though it is not very unsure for me why this happens often in my system, I could find out some workarounds to resolve… [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]
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.
Excel VBA Find String in Range Return Row Change Background color Remove Duplicates. Get code to perform search operation for a string in worksheet cell range. Also use the same to find duplicates, change cell color based on value, find row of search string …
Excel VBA code to Loop through all Open Workbooks. Also, use the same code to get names of all the open workbooks. This is useful to scan though & get the properties of any number of open workbook in the current system.
- 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