excel vba exampels

How to Count Cells by Font Color in Excel

This post will guide you how to count cells by font color in Excel. How do I Count the number of cells with specific cell Font color by using a User Defined function in Excel. Count Cells by Font Color Assuming that you have a list of data in range B1:B9, in which contain some… read more »

How to Rename Multiple Files with VBA Macro in Excel

This post will guide you how to rename multiple files in a given directory with VBA Macro in Excel. How do I quickly rename multiple files at once in Excel. Rename Multiple Files with VBA Assuming that you have multiple files and the format for all filenames like this: test1.xlsx, test2.xlsx…etc. You want to rename… read more »

Sort Worksheets in Alphabetical Order

This post will guide you how to sort worksheet tabs in alphabetical order in Excel. How do I sort worksheet by alphabetical order with VBA Macro code in Excel. How to quickly rearrange your worksheet tabs in alphabetical order with VBA code in Excel. Sort Worksheets in Alphabetical Order Assuming that you have 5 worksheets… read more »

Sidebar