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 …

How to Make a Lucky Draw in an Excel Worksheet via VBA 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 …

2 Methods to Find the Largest or Smallest N Items in Your Excel Worksheet 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 …

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