Python is the becoming the language of choice for pretty much every arena. It is a very simple yet extremely powerful programming language. It is a scripting language that is widely used for prototyping to get work up and running...

The user is unfamiliar with what containers are available and how they are used.

• Begin by introducing the user to the different categories of conta
iners
• Familiarize the user with the abilities that each container has...

In this lesson, we write values to the four corners of the spreadsheet using the Range.End property and discuss the predefined constants (enumerations) passed in as arguments.
r/>
This clip is from the chapter "Range...

In this lesson, we explore this with the context of Worksheet objects inside the Worksheets collection.
r/>
This clip is from the chapter "The Fundamentals of the Excel Object Model" of the series "Excel VBA Programming–The...

The F8 key allows us to step through the lines of a procedure step by step. In this lesson, we see how this functionality grants tremendous power when debugging a complex piece of code.
r/>
This clip is from the chapter...

In this lesson, we explore 5 additional utility functions available in the Visual Basic Editor:

• Left for pulling out characters from the beginning of a s
tring
• Right for pulling out characters from the end o
f a...

If zero-based indexing is confusing, the Option Base 1 keywords at the top of a module force an array to start at an index position of 1. In this lesson, we enable this setting and see its results in a newly declared array.
r/>
...

In this lesson, we use the InputBox function to collect a new worksheet title from the user. The InputBox is a basic dialog box with a single text entry field, a prompt, a title, and OK / Cancel buttons.
r/>
This clip is from...

The Exit For keywords prematurely terminate a For loop. The Exit Sub keywords prematurely terminate a procedure. In this lesson, we practice implementing these concepts.
r/>
This clip is from the chapter "Iteration" of the...

The Range.SpecialCells method extracts a subset of cells from a Range based on a criteria -- empty cells, cells with constants, cells with formulas, etc. In this lesson, we populate a column with various values and use the method to...

In this lesson, we continue our exploration of absolute vs relative references by recording a macro that deletes a row from the worksheet. Absolute references explicitly target a specific row each time, which defeats the purpose of the...

Unit Testing with Junit: Step 10: Testing Performance in JUnit Tests
r/>
This clip is from the chapter "Unit Testing with Junit" of the series "Mockito Tutorial: Learn mocking with 25 Junit Examples".In this section, we look...

From the section: More Complex Algorithms on Arrays. In this section, we will deal with even more complex problems involving arrays. They will require more complex logic or data structures to solve, or a clever way of applying more...

In this video, understand how to use structured bindings to bind variables to different members of an object or an array.
r/>
This clip is from the chapter "C++17 Core Language Features" of the series "Complete Modern C++".This...

What the Font object is to the foreground, the Interior property is to the background. In this lesson, we use the Range.Interior property to modify the color of a cell in a variety of different ways including:

• VBA color...

The Range.TextToColumns method splits a string based on a delimiter, a special symbol. In this lesson, we use this feature to separate several strings, applying a variety of delimiters (commas, spaces, even custom vertical pipes) along...

The Range.Replace method acts as a Find-and-Replace search mechanism. In this lesson, we apply it to a range of values in column A and discover a unique quirk when it comes to replacing numbers.
r/>
This clip is from the...

In this lesson, we continue to expand on the R1C1 concepts introduced in the past lesson by applying them to several real-life examples.
r/>
This clip is from the chapter "Range References" of the series "Excel VBA...

The Range.EntireRow and Range.EntireColumn properties are used to target a complete row or column from a single cell. In this lesson, we play around with the two properties in the Immediate Window.
r/>
This clip is from the...

The Range.Row and Range.Column properties return numbers that represent the numeric position of the cell's row and column relative to the spreadsheet. If a multi-cell Range is used, VBA uses the top-left cell as its reference point. In...

In this lesson, we use the Range.Count and Range.CountLarge properties to find out the number of cells in a given range. The returned value counts all cells, not just those with values.
r/>
This clip is from the chapter "Range...

The Application.DisplayAlerts property is used to enable or disable user alerts in Excel. An alert is a dialog box that warns the user of an impending operation. It's a helpful feature but can be distracting when the user is executing...

The Worksheet.Copy method copies the contents of a worksheet to a new worksheet. When invoked with no arguments, it will create the copy in a brand new workbook. With either a Before or After argument, the copy will be placed in the...

In this lesson, we dive into predefined constants or enumerations. These are constants built into the VBA language itself that evaluate to numbers. They are used internally by VBA whenever several options are needed that cannot be...