Curated Video
Excel VBA Programming The Complete Guide - The Range.End Property
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. This clip is from the chapter "Range References" of the...
Curated Video
Excel VBA Programming The Complete Guide - Access Object from Collection by Name
In this lesson, we explore this with the context of Worksheet objects inside the Worksheets collection. This clip is from the chapter "The Fundamentals of the Excel Object Model" of the series "Excel VBA Programming–The Complete...
Curated Video
Excel VBA Programming The Complete Guide - Stepping Through Code
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. This clip is from the chapter "Debugging" of the...
Curated Video
Excel VBA Programming The Complete Guide - VBA Functions, Part II
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 string • Right for pulling out characters from the end of a string • Mid for...
Curated Video
Excel VBA Programming The Complete Guide - The Option Base 1 Syntax and Write Array Values to Cells
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. This clip is...
Curated Video
Excel VBA Programming The Complete Guide - The InputBox Function
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. This clip is from the chapter...
Curated Video
Excel VBA Programming The Complete Guide - Exit For and Review of Exit Sub
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. This clip is from the chapter "Iteration" of the series "Excel VBA...
Curated Video
Excel VBA Programming The Complete Guide - SpecialCells
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...
Curated Video
Excel VBA Programming The Complete Guide - Absolute vs. Relative References II
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...
Curated Video
Mockito Tutorial: Learn mocking with 25 Junit Examples - Step 10: Testing Performance in JUnit Tests
Unit Testing with Junit: Step 10: Testing Performance in JUnit Tests 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 into unit...
Curated Video
Describe an advanced data structure : Efficiently Counting Subarrays with a Given Sum
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 than...
Curated Video
Complete Modern C++ - Structured Bindings
In this video, understand how to use structured bindings to bind variables to different members of an object or an array. This clip is from the chapter "C++17 Core Language Features" of the series "Complete Modern C++".This section...
Curated Video
Excel VBA Programming The Complete Guide - The Range.Interior Property
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 constants • The...
Curated Video
Excel VBA Programming The Complete Guide - The Range.TextToColumns Method
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...
Curated Video
Excel VBA Programming The Complete Guide - The Range.Replace Method
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. This clip is from the chapter "Range...
Curated Video
Excel VBA Programming The Complete Guide - R1C1 Notation, Part II
In this lesson, we continue to expand on the R1C1 concepts introduced in the past lesson by applying them to several real-life examples. This clip is from the chapter "Range References" of the series "Excel VBA Programming–The Complete...
Curated Video
Excel VBA Programming The Complete Guide - The Range.EntireRow and Range.EntireColumn Properties
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. This clip is from the chapter "Range...
Curated Video
Excel VBA Programming The Complete Guide - The Range.Row and Range.Column Properties
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...
Curated Video
Excel VBA Programming The Complete Guide - The Range.Count and Range.CountLarge Properties
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. This clip is from the chapter "Range References" of...
Curated Video
Excel VBA Programming The Complete Guide - The Application.DisplayAlerts Property
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 a...
Curated Video
Excel VBA Programming The Complete Guide - The Worksheet.Copy Method
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...
Curated Video
Excel VBA Programming The Complete Guide - Predefined Constants
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...
Curated Video
Excel VBA Programming The Complete Guide - The Immediate Window and Debug.Print Method
The Immediate Window is a console or playground within the Visual Basic Editor that allows the developer to test out snippets of VBA code. The IW can be used to get or set property values, invoke object methods and more. In this lesson,...
Curated Video
Excel VBA Programming The Complete Guide - The Name Property on Workbook and Worksheet Objects
In this lesson, we explore the Name property on both a Worksheet and Workbook object. The Name property is only readable on a Workbook but is readable and writeable on a Worksheet. The key takeaway is that object design differs; just...