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...
Curated Video
Excel VBA Programming The Complete Guide - The Worksheet_Activate Event
The Worksheet_Activate event is triggered when the user navigates to a different worksheet. It can be used to provide the user with instructions or warnings. In this lesson, we write a quick procedure to MsgBox out the activated sheet's...
Curated Video
Excel VBA Programming The Complete Guide - Dynamic Arrays
A dynamic array can be resized repeatedly throughout a procedure to hold a different number of elements. This can be helpful when we cannot predict an array size in advance. In this lesson, we use a dynamic array to contain a list of...
Curated Video
Excel VBA Programming The Complete Guide - The For Each-Next Construct
The For Each construct iterates over every single object in a collection. In this lesson, we practice iterating over the Workbooks and Worksheets collections. This clip is from the chapter "Iteration" of the series "Excel VBA...
Curated Video
Java Programming for Complete Beginners - Java 16 - Step 04 - Java Arrays - Compare, Sort, and Fill
In this session, we will learn about Java arrays - compare, sort, and fill. This clip is from the chapter "Arrays and ArrayLists" of the series "Java Programming for Complete Beginners - Java 16".In this section, we will explore Java...