iLearn Excel VBA: Cells and Ranges
Cells and Ranges . . . I’m lost already!
If you open up Excel you will see countless boxes. These boxes are called Cells. You can store many different kinds of variables within these cells including numbers, strings, and even dates. If you highlight a bunch of cells (click on a cell and while holding the left click down, drag your mouse to another cell), you just selected a Range of cells. The row numbers are on the left and the column numbers are denoted as letters across the top row. Now that definitions are out of the way, we can move on to cell manipulation. (more…)
iLearn Excel VBA: Select-Case
The Forgotten Select-Case
The Select-Case is often ignored when programming as it can be easily substituted with If-Then-Else statements. It functions much like a If-Then-Else statement and computes a conditional where if true, completes a segment of code. Let’s look at the example: (more…)
