Manager

Sponsored Links
Excel Macro (VBA)

How to use the input screen "InputBox" Excel Macro (VBA)

If you want to use values or arbitrary characters that do not exist in Excel, the "InputBox" is useful to easily create an input screen during macro execution. In this article, we will briefly explain how to use this "InputBox".
2025.02.21
Excel Macro (VBA)
Excel Functions

How to extract after a specific character "RIGHT function and FIND function" Excel (Excel)

As shown in the figure below, when the data to be extracted is contained after a string and the number of characters of the data to be extracted is not constant, the RIGHT function alone cannot be used to extract the data. Function to extract the data after the "¥" mark in cell "A2" = RIGHT(A2,LEN(A2)-FIN...)
2025.02.18 2025.02.19
Excel Functions
Excel Functions

How to extract characters before a specific character "LEFT and FIND functions" Excel (Excel)

As shown in the figure below, if there is extra data after the string and you want to extract only the string to the left of the extra data, you cannot simply use the LEFT function alone because the number of characters is not constant. Function to extract the left side of the "¥" mark in cell "A2" = LEFT(A2,FIND(...))
2025.02.18 2025.02.19
Excel Functions
Sponsored Links
Excel Macro (VBA)

The Complete Guide to IF AND in VBA｜Thorough explanation from basic syntax to practical techniques

I want to combine IF and AND statements in VBA, but I don't know how to write it..." I have experienced such a problem. Actually, the way to write it is a little different from the IF function in Excel. In my 20 years of Excel work, I have used IF AND in VBA to automate many tasks...
2025.02.12
Excel Macro (VBA)
Excel Macro (VBA)

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 Functions

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
spreadsheet

2 ways to show/hide "0" in calculation results Spreadsheet

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 two ways to avoid displaying numbers when the result of the calculation is "0" zero. The result of the calculation is "0" zero...
2024.10.29 2024.11.13
spreadsheet
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
Edge

How to change the name (display name) of the digital certificate at login [Edge].

When logging in with a digital certificate for Internet banking, etc., if there are multiple banks using the same system, there will be multiple digital certificates, and you will need to select the one you want to use when logging in...
2024.10.16
Edge
Windows

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)
Sponsored Links
Next page
Copied title and URL