Excel VBA Basics #2 - Using the Cells object with and without range object, named ranges

In this video, we learn how to:
Use the CELLS object, Use Cells object with Range object, Use the Range object to affect a "named range" -IMPROVED AUDIO

Fantastic Developer Tools:

[rajassy]

As usual, a great video, THANK YOU Dan!
This is what I learned from this video
- Use Cells as a Property [Note: the snytax is 'Cells' not 'Cell]
- Use Cells Property within Range Object
- Using a variable within Cells Property
- Use Column reference such as "C" or "AC" within a Cells property instead of an index, comes handy instead of counting index number for column "CK"
- Easy/Lazy way to refer a range using a square bracket (from a use comment)

God Bless

[excelisfun]

Thanks so much for this video # 2! Love the Cell object!

[jgautam]

This is the best I found on net for learning VBA. Many thanks for your hard work.

[ExcelVbaIsFun]

Merry Christmas everyone. I hope God blesses you richly this upcoming year. Remember, you ARE a success!! Believe it, be it! Blessings my friends!! Dan

[ExcelVbaIsFun]

Awesome, arka! You're welcome. Thanks for watching!

[Excel]

Time ago and I'm looking for educational videos for vba
Thank you very much and we hope a detailed explanation to reach the professional stage

[AdrianHyatt]

God bless you too, Dan. This feed is gold.

[arkatrina]

Finally found a proper excel vba tutorial Thanks man!!!!

[ExcelVbaIsFun]

I'm glad to help! Let me know if you have any questions/ video topics or projects you have, maybe I can help. Dan

[s]

Thanks for making the VBA videos, I like your videos which is predominantly VBA and Mike Garvin Excel basics to advance videos, easy to follow and entertaining in regards to the style of teaching from both Excel guru, hopefully I will use your site to post some technical VBA questions that I have problem understanding. Good work, looking forward to more video posting. Thanks

[javedahmed]

I got the point I was looking for. Thanks.

[excelsocallmaster]

What most people know is that cells object also supports column text name so cells(6, 3) can also be written as cells(6, comes in handy when you are referencing bigger columns

[mxrvxn]

im new to programming, and ur vids easy to follow and understand. thank u so much

[ExcelVbaIsFun]

Great, keep it up! Please ask if you have any questions! -Dan

[mysimonhughes]

this is good - thanks for taking the time to make the videos

[Computertechlighthouse]

Two cores of vba that I concern up to this video:
1. range
2. cells
Thank you Sir!

[gerelltroche]

Running these videos at 1.25 speed is fantastic. Whenever I listen to your voice at normal speed i feel like you're talking in slow motion haha

[maribelflores]

Thank you man. Very successful video. God bless you too!!

[userme]

I just started seeing your videos. This is my second one. I am hoping to see a video which shows how to use a form to enter data in excel cells. So far your videos are amazing and the way you started is excellent. Well done and thanks a lot. Excellent job.

[felipe_meira]

best videos of excel, i´m learning everything of VBA with your lessons. Thank you so much.