VBA - for loops, iterator and using cells

In this Excel VBA tutorial, we’re going to learn about Cells (instead of using Range) and for loops.

n this example, I’ve started with Option Explicit so I have to declare all my variables before using them, and I’ve created a Sub called using_cells().

When I start to type Cells( the highlighted yellow box will pop up giving me a guide on how to use it correctly. Specifically, it’s asking you to use a row number and a column number. This is different from Range where you would use the cell number such as B3. With Cells, we don’t use letters at all.

So the correct way to select a cell is Cells(9, 6).select. This would select the 9th row down and the 6th column from the left (column F).

Read more and copy the code from the blog post

Do you have more to add? Let me know how you liked the video or if I need anything corrected in the comments below.

#contentinsider #youtuber #smallyoutuber #smallytchannel #udemy
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

TECH GEAR I USE DAILY

OTHER COURSES I CURRENTLY TEACH

Let's chat
#CommisionsEarned
As an Amazon Associate I earn from qualifying purchases.