Learn how to sort by color in Excel using menu & VBA code. You could sort either by cell background color or the font color. Get this free code sortbycolor.
VBA – Check for Active Internet Connection – Network Status
Get VBA Code to check if the Internet connection is active. This code uses Windows API function to get the Computer’s Network connection status.
How to calculate Percentage in Excel?
Learn how to calculate percentage of nunber against a grant total in Excel & also the reverse. i.e., how do I calculate 10% of a number using plain Excel formula.
Anagram Maker – Solver Free Download – Excel App
November 25, 2024
Anagram Solver Basic App This Anagram Maker app does not require any installation other than MS Excel. It requires MS Excel to be already installed with VBA macros enabled. This app is developed using MS Excel Vba macro programming. You can input any word in this app. It has a […]
Excel VBA Check for Anagram words
November 25, 2024
Check if Two words are Anagram Anagrams are two or more different words with same combination of letters. For example: now, won, own How do we compare & verify if the two words are Anagrams or not? We can follow different logic, as discussed in here. VBA code to Check […]
Disable Autofilter Excel VBA – Filter Switch On OFF
VBA Code to check if Autofilter is on or off in a worksheet or any sheet in the workbook. Get VBA code to check the status and also to toggle the autofilter
How to Zip Directory using Python? – Archive folder
November 25, 2024
Archive or Zip all files in Directory The code in this page will Zip directory full of files. It will first get folder path as input. Then loop thru the directory & its sub-directories to get all the files list. Then each file in the list is added to the […]
List all Excel VBA Environment Variables – Username
Read Excel vba environment variables using the code snippets. This code reads complete list of all environment variables defined in the system.
Rename a File in Python – or List of Files in a Folder – Free Code
Get this code to rename a file in Python or list of files in a folder with simple easy way. Also, you can copy its content to a new file.
Enable Cut/Copy/Insert/Delete Options in Excel Right Click
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 […]