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
https://markgingrass.com/2019/08/25/vba-for-loops-iterator-using-cells/

http://bit.ly/sub_to_chan

➔ Everyone should download TubeBuddy! http://bit.ly/t_buddy
➔ Blue Yeti Mic: https://amzn.to/2IheZTG
➔ 2 Months SkillShare Free➔ https://www.skillshare.com/r/profile/...

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
➔ I work on a MBP: https://amzn.to/2XxeBsG
➔ Blue Yeti Mic: https://amzn.to/2IheZTG
➔ Swissgear Backpack: https://youtu.be/VTTnRMyFkB8
➔ mTuber for Title Effects : https://motionvfx.sjv.io/3M3KM
➔ mArrows for animated arrows: https://motionvfx.sjv.io/9B3oe
➔ MICROPHONE - https://amzn.to/2LYfJkr
➔ BACKPACK - https://amzn.to/2Ep4uez
➔ GREEN SCREEN - https://amzn.to/2JVzMgP
➔ TRIPOD - https://amzn.to/2Eo2wv4

Music: https://www.bensound.com/

HOMEPAGE - https://www.markgingrass.com/
REVIEWS/BLOG - https://www.markgingrass.com/blogs/re...

OTHER COURSES I CURRENTLY TEACH
➔ C++ Course: http://bit.ly/cpp_course
➔ Supply Chain Management: http://bit.ly/scm_course

Let's chat
https://www.facebook.com/GingrassOnline/
https://www.instagram.com/markgingrass/
#CommisionsEarned
As an Amazon Associate I earn from qualifying purchases.