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

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

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

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

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

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

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

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