Excel VBA - Cell Referencing

Excel VBA - Cell Referencing
Watch More Videos at:
Lecture By: Mr. Pavan Lalwani Tutorials Point India Private Limited

[TutorialsPoint_]

Use coupon "YOUTUBE12" to get ‘’FLAT 12%’’ OFF at Checkout.

[gaminxden]

I find it really amazing that Indians are good in explaining things clearly. Easy to understand. Straight forward. Awesome.
Big hands from Philippines.

[hshrestha]

Thanks to Indians in Youtube, who have made my programming journey easier.
Respect from Nepali in Germany.

[KatieMcTalmage]

Thank you, you are an excellent teacher! So many videos just discuss how to use the simple button for macros, but I wanted to see what is working behind the scenes. Thank you for your very clear description.

[idrisabismailhadjoudja]

Thank you very much:

Sub cell referencing ()
ActiveCell.Value = "tutorials"
ActiveCell.Value = 40
[b5].Value = 70
[c1:c10] = "Tutorials"
Cells(8, 2).Value = "India"
Range("al").Value= "Mumbai"
Range ("a2:a10") = "Jakarta"
End sub

[mohansneha]

Thank you so much for your elaborate and simple explaination for understanding the intricacies of cell reference and making beginning in vba. I am a senior citizen involved in environmental consultancy and was looking desperately for simple yet fast tools in processing vast range of data. God bless you.

[Karthikng]

My Reference:

ActiveCell.Value = "Testing"
[b2].Value = "method 1 "
[d1:d5].Value = "method 2 "
Cells(6, 2).Value = "method 3"

Range should be always used with double quotes and it should contain the cell address

Range("C1").Value = "method 4 recommended"
Range("C1:h14").Value = "method 5 recommended"
Range("C1", "H15").Value = "method 5 recommended"

[shivamsinghal]

Sir, I dont have any word to describe your teaching method, Hats

[evi]

Good explanation. Never been this far watching someone explain VBA.

[sangeethamadambi]

I liked your statement ; "Mumbai is a city in India." Such a meticulous thinking..
beginners like me will be very happy with this..

[jayanthikanagaraj]

Actually it is very interesting to listen because all video timing only for few mins not for so long
Thanks a lot for created a presentation on macros

[sidharathsharma]

Even the highest rated udemy courses can't match your level of teaching sir. U are the best, sir.

[daudacademy]

The method you taught seems very simple to me. I like your presentation very much. You are a very good teacher.

[akhil_c_mani]

Very much understandable way of teaching...Appreciate your effort sir

[varshasingh]

Thanks a lot sir....First time i got a clear idea about VBA

[flotin]

It was great to learn that I could simply reference between "[ ]". This way is faster and cleaner! Very nice

[muzaffarraja]

Perfect Tutorial, very nice way of teaching.

[gauravnagarkar]

Excellent! I am a beginner and this tutorial helps me a lot.

[vikaskpadale]

Excellent, I really appreciate your effort, Thanks A Ton Again :-)
This is proper way of teaching, step by step mentioning minor things along the way and all in a short 5-6 min video
Awesome presentation FIRST TIME I GET WORD BEST TUTORIAL .
Very Unique way of teaching, You are Great Trainer Keep it up.

[satheeshiyer]

What a clarity you have and the way you teach is amazing.. I love your videos and your style.. :))