Excel Functions

Excel Macro (VBA): How to use the CountIfs function in VBA!

If you are a beginner who wants to use Excel's COUNTIFS function in VBA, this is a must. This article provides a thorough explanation from basic writing to error handling. In fact, with a few tricks, you can reduce processing time from a few minutes to a few seconds. Read this article and you will be able to efficiently tabulate data from tomorrow.

2025.02.10 2025.02.12

Excel Macro (VBA)

Excel (Excel) 4 methods to write vertically, each with its own characteristics and uses.

Excel is normally designed to be written horizontally, but it can also be written vertically. There are several ways to do this, but in this article, we will introduce four methods, two using "cell formatting" and two using "text boxes. Using "Vertical Writing" Cell Formatting1....

2024.11.11 2025.05.30

Excel Functions

3 ways to show/hide "0" in calculation results Excel (Excel)

As shown in the figure below, when "A1" cell contains 150 and "A2" cell also contains the same number, 150, the calculation result of "=A1-A2" is "0" zero. There are three ways to avoid displaying numbers when the result of the calculation is "0" zero. The result of the calculation is "0" zero...

2024.10.26 2024.10.29

Excel Functions

How to Enable Excel Macros: Fix 'Macro Has Been Blocked' Error Safely

Due to Microsoft security enhancements, starting with Excel version 2203 and later, when Excel with macro functionality is downloaded from the web, the following red band message appears and macros can no longer be executed. In this issue, we will discuss this...

2024.10.11 2025.05.30

WindowsExcel Macro (VBA)

VBA "Overflow occurred." Error cause and remedy (runtime error '6′:)

Cause of ErrorThis error occurs when the data type is not in a format that can be handled, or when the data type exceeds the range of numbers that can be handled. First, let's reproduce the error. As shown in the figure above, we have set up the code to copy the numeric value in cell "B3" to cell "B4".

2024.10.10

Excel Macro (VBA)

Forgot password] How to remove read-only (write password) Excel

Files with a "write password" can only be opened on a read-only basis unless the password is known. However, if you must remove the protection and write to the file, but the person in charge of applying the protection has already left the company, or the memo has been lost...

2024.10.08

Excel Functions

Forgot Password] How to remove sheet protection Excel (Excel)

I have a "sheet-protected" Excel file that I really need to unprotect, but the person in charge of applying the protection has already left the company or lost the memo, and I don't know the password. In such cases, do I have no choice but to give up? No, you can...

2024.10.08 2024.10.29

Excel Functions

For beginners] Explanation of causes of Excel being slow and countermeasures.

Manager, have you ever felt 'kind of heavy' when using Excel? Student Yes, sir! I recently started using Excel to improve my business, but I'm having trouble opening files because it takes so long. ManagerYes, that's right. Many people have the same problem...

2024.10.01 2024.10.02

Excel Functions

For beginners] Detailed explanation of EdgeDriver installation procedure

EdgeDriver is an indispensable tool for automating Edge browser operations using VBA; it can greatly improve the efficiency of your daily work by automating web operations. However, many people are hesitant to install the first step in this process...

2024.10.01 2024.10.15

EdgeExcel Macro (VBA)

Clipboard error in Excel: "Used by another application..." and emergency measures

As of September 2024, about a month ago, I started getting this error message often when repeatedly copying and pasting in Excel. Clipboard ErrorCan't copy content to clipboard because it is being used by another application...

2024.09.20 2025.05.30

EdgeExcel Functions