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.
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.
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.
Use this method to open vcf file without using any special converter apps. With this method, you will be able to view the complete detail of a vCard file.
Use this VBA code or Excel app to create Email List using Excel. Created distribution list can be used to email to multiple recipients for Marketing purpose