Compare two columns in Excel with huge volume of data. Easy tips to compare to find matching data, highlight duplicate entries using countif formula.
Get Excel VBA to count cells by color. Input range. Use this to also perform color by sum, sumbycolor or countbycolor tasks. Its all about sum by color.
Excel VBA Color Index List contains 56 colors that is used in the Color palette to change the background color, border or font color. Code for VBA Color.
Learn how to use whatsapp with different numbers on 1 phone. Different methods to do WhatsApp Dual Login for multi sim phones. No need to root.
Conversion of Excel VBA color codes from Long to RGB, Hex and vise versa. VBA color codes can be used on Excel background,interior or font color codes.
Activate WhatsApp Video Call to any user. Here is what all you need to know to make Video chat. WhatsApp with Official Beta version with Video Call
Create Drop down list in Excel. It is also called Data Validation list which allows users to enter only predefined values. VBA data Validation list also.
Read the output of Excel vba shell command within macro.Issue any function to execute shell command prompt thru vba Shell & read the output in Excel Macro
Coding Excel VBA 64 bit compatible for 32 bit. Also convert VBA 32 bit to 64 bit by declare PtrSafe 64 bit of Win API functions of VB6 & VB7 editor.