Sponsored Links
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...
Excel Functions

How to apply mosaic (blur) Excel

When you are preparing a document or manual for external publication, you may need to refer to a web site or a screen where non-public information is visible. In such a case, you would like to put a mosaic like this on the non-public part. We will explain this method in detail in this issue...
Excel Functions

3 Easy Ways to Hide or Show Zero Values in Excel: Simple Formatting Tips

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...
Sponsored Links
Excel Functions

Allows you to see the address where the book is saved Excel (Excel)

You can display the path in the toolbar so that you can always see the address where you saved your Excel book. We will show you how to do this in this article. Click on the "File" tab, click on "Options", click on "Quick Access Toolbar" > "All...", and then click on "Quick Access Toolbar" > "Quick Access Toolbar" > "All...".
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".
Excel Macro (VBA)

Color every other line alternately to make stripes.

When creating a table, it is possible to make the table very easy to read if each row is colored alternately and striped. In this issue, we will show you three ways to do this. How to use the table functionHow to set up a tableSelect a cell anywhere in the table you want to make a table and click "Insert...
Excel Functions

How to find function references with trace arrows Excel (Excel)

If you are confused about reference relationships in Excel functions, you have come to the right place! This article details how to find references using trace arrows. In fact, you can easily visualize the relationship between cells from the formula tab. This article will help you understand complex functions.
Excel Macro (VBA)

How to Find the Last Row in Excel Using VBA (Macro Guide for Beginners)

We show you how to find the data from the top of the data and how to start from the bottom row of the Excel file and work your way up.
Excel Functions

Creating a QR Code in Excel (Excel)

QR codes are a very convenient way to tell someone a URL or email address, rather than a string of text. It is a very convenient tool because all the recipient has to do is read it. However, the only way to make them is to create and download them using free sites on the Internet...
Excel Macro (VBA)

How to install .NET FrameWork

What are the versions of the .NET Framework? NET Framework (DotNet Framework) comes in various versions (types of toolboxes) with slightly different tools inside...
Sponsored Links
Copied title and URL