Excel Macro (VBA) How to use the variable type "Workbook" Excel(Excel) Macro(VBA) For other variable types, please refer to Excel (Excel) Macro (VBA) about variable types. First, we will explain the basic usage of the variable type "Workbook". 2024.06.14 Excel Macro (VBA)
Excel Functions Automatically create invoices from sales invoices1 Excel (Excel) There are many useful software systems that automatically output invoices as you record sales data if you pay for them, but many people are unable to install software because they "don't have enough money to pay for it" or "management won't allow it" and are making each invoice by hand... 2024.06.10 Excel FunctionsLet's make an invoice from a sales invoice.
Excel Macro (VBA) How to pass arguments between procedures ByRef,ByVal Excel(Excel) Macro(VBA) This section describes how to pass arguments when procedures are separated. In the article below, I mentioned that it is easier to read and process the code by separating the procedures... 2023.12.27 Excel Macro (VBA)
Excel Functions Switch between manual and automatic recalculation methods in Excel (Excel) Excel, which contains a large number of formulas, will recalculate each time you perform some operation, and you will not be able to perform the next operation until the calculation is finished. If you feel that Excel is too slow, you can stop the recalculation to make it run more smoothly. Also, for some reason without realizing it... 2024.05.30 Excel Functions
Excel Macro (VBA) Measure macro processing time Excel(Excel) Macro(VBA) When trying to speed up a macro, it is first necessary to be able to determine how much time was saved before and after the improvement, and how much time was saved or not. To do this, it is necessary to be able to measure the time. In this article, we will show you how to do this. In this article, we will discuss the process of... 2024.01.03 Excel Macro (VBA)
Edge How to Change Digital Certificate Display Names in Microsoft Edge for Easy Identification How to Change Digital Certificate Names in Edge | Stop Certificate Confusion. Set friendly names for easy identification. Step-by-step guide to distinguish multiple certificates in Microsoft Edge browser. 2025.07.03 Edge
Excel Functions Excel (Excel) Conditional Formatting Methods Excel has a function to change the format according to cell values and various conditions. Here is an example of a specific setting. Suppose you have a simple table like the one below, and you want to shade in red the cells where no sales have been entered. First, select the range you want to format. Next, select "Home"... 2023.12.27 Excel Functions
Windows How to display file extensions [Windows 11]. For the beginning computer user, there may be little trouble with file extensions not being displayed. However, once you have started to tinker with computers to some extent, there are situations where you may need to change the file extension or process a file differently depending on its extension, so this... 2024.10.08 Windows
Excel Functions How to set up a link by inserting a hyperlink Excel (Excel) Here is how to set up a hyperlink using the Insert Hyperlink function. For example, let's say you have created a document with a table of contents as shown below, which jumps to a cell within the page. Let's say you have created a page with a table of contents as shown in the figure below, and when you click on the name of an item in the table of contents, you will jump to that item. First, let's create a page with a hyperlink to a cell in the page... 2024.07.03 Excel Functions
Excel Macro (VBA) [For Beginners] Step-by-Step Guide to Installing SeleniumBasic This article offers a beginner-friendly, detailed guide to installing SeleniumBasic. Stuck on the installation and thinking about giving up on automation? The truth is, anyone can install it by taking it one step at a time. A professional with 20 years of experience teaching Excel will walk you through the process. 2025.06.16 Excel Macro (VBA)