Posts Tagged 'insert module'

How to Make a Lucky Draw in an Excel Worksheet via VBA

In Excel worksheet, you can also make a lucky draw. In this writing piece, we are going to show you how to finish this task in Excel. A Lucky draw is very common in our daily life. For example, you need to give bonuses to employees in the end of a year. You would like to select some lucky employees randomly. Therefore, you can use the Excel file to make a lucky draw. Make a Lucky Draw In this part, we will introduce the methods in detail. Open the Excel file with all the information...

Read more »

2 Methods to Find the Largest or Smallest N Items in Your Excel Worksheet

Sometimes you need to find the largest N items or the smallest N items in a range in your worksheet. Here we will provide two effective methods for you. Finding the largest N items or the smallest N items in a range is a very ordinary task in your work. In our previous article How to Highlight the Top or Bottom N Items by Conditional Formatting in Excel, we have introduced the methods of using conditional formatting. And in the following part, we will discuss about the two other methods in...

Read more »

How to Quickly Add Comments to Cells in Your Excel Worksheet via VBA

In certain circumstance, you need to copy comments into designated cells. Here we will introduce a quick method to finish this task. In the image below, you can see there are two comments in the worksheet. And to make the interface cleaner without hiding those comments, you can copy comments into certain cells. If you do this task manually, you will certainly spend a lot of time, especially when there are many comments. Hence, you may refer to the method below. Copy Comments into...

Read more »