More Than 10 Ways to Speed Up Macros

"All roads lead to Rome", the same task can also be accomplished in different ways in VBA. When starting to learn programming, […]

How to: Put Double Quotes in a String in Excel VBA

In VBA, strings assigned to variables or properties are enclosed in double quotes "", Sometimes you might want to place Double Quotes […]

How to Quickly Copy Values Without Formulas in Excel?

This article will guide you to quickly copy values without formulas in Excel. The example may be easier to understand if you […]

limit Scroll Area on an Excel Worksheet

Sometimes, if you want to limit scroll area of an Excel worksheet, it means that the cells outside the scroll area cannot […]

Complete List of Excel VBA Editor Keyboard Shortcuts

The complete list of Excel VBA Editor (VBE) keyboard shortcuts are for U.S. keyboard layout and Windows Operation system. See also: Complete […]

How to Rebuild Data, Case Study

Sometimes we deal with data that is not standardized that we might give up, you should learn how to rebuild you data, […]

How To Quickly Insert Blank Rows Between Existing Rows In Excel

Sometimes, you may need to dynamically insert blank rows between each of the existing rows into your Worksheet. Although blank rows are […]

How to Quickly Combine the Contents of Multiple Cells Into One Cell in Excel

You can use the ampersand (&) operator in a formula to combine text from multiple cells into one cell, such as a […]