This Excel VBA tutorial explains how to generate non-duplicated random number using Excel VBA. You may also want to read: Generate random letter A to Z Generate random HKID Hong Kong ID Excel VBA generate non-duplicated random number In my previous post, I demonstrated how to assign random number to a value using Rank Function and Rand Function. In this post I will introduce a more direct approach to assign a random number with the help of VBA. In this approach, each time after a r...

This Excel VBA tutorial explains how to add password to all Excel workbook in folder and how to mass remove password. You may also want to read: Excel VBA protect worksheet with password Excel VBA hide worksheet with password (xlVeryHidden) Protect VBA code with password Add password to all Excel workbook in folder In many organizations, employees are required to add password to Excel before sending workbooks through email, or before putting workbooks in network drive. If you have ...

This Excel VBA tutorial demonstrates how to combine worksheets columns into one worksheet. You may also want to read: Excel VBA Consolidate worksheets with same structure into one worksheet Excel VBA consolidate multiple workbooks into one workbook Excel convert data from column to row Excel VBA combine worksheets columns into one worksheet There are two types of combine worksheets Worksheets have the same structures / headers, create a blank worksheet and paste the data from diff...

This Excel tutorial explains how to use Excel VBA to compare worksheets. You may also want to read: Excel compare Worksheets using Compare File Excel compare worksheets Compare worksheets is to compare worksheets of similar structures but different values. Excel has a built it function called Compare File in Office Professional Plus 2013 or Office 365 ProPlus. After comparison is complete, two worksheets are compared side by side and you get the below result indicating all the difference...