Excel VBA - Cell Referencing
Excel VBA - Cell Referencing
Watch More Videos at:
www.tutorialspoint.com/videot...
Lecture By: Mr. Pavan Lalwani Tutorials Point India Private Limited
Excel VBA - Cell Referencing
Watch More Videos at:
www.tutorialspoint.com/videot...
Lecture By: Mr. Pavan Lalwani Tutorials Point India Private Limited
Пікірлер: 174
Get Certified in Excel VBA:bit.ly/41fWeVP Use coupon "KZread12" to get ‘’FLAT 12%’’ OFF at Checkout.
I find it really amazing that Indians are good in explaining things clearly. Easy to understand. Straight forward. Awesome. Big hands from Philippines.
Thanks to Indians in KZread, who have made my programming journey easier. Respect from Nepali in Germany.
What a clarity you have and the way you teach is amazing.. I love your videos and your style.. :))
Very very.. excellent explanation brother..! 🎉🎉
Great presentation! Thank you very much for your effort.
Good explanation. Never been this far watching someone explain VBA.
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
Excellent. Explained in a very easy and simple way. Thank you
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.
Love watching your video! Thank you so much!! These all are really beneficial!
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.
@abhishekvrm2777
2 жыл бұрын
Hello sir, when did you leave RSS?
The method you taught seems very simple to me. I like your presentation very much. You are a very good teacher.
Excellent, I really appreciate your effort, Thanks A Ton Again Mr. Pavan Lalwani
It was great to learn that I could simply reference between "[ ]". This way is faster and cleaner! Very nice
@gaminxden11
5 жыл бұрын
Same here Flavio H. Campos. Yeah, I agree.
Sir, I dont have any word to describe your teaching method, Hats off......
I liked your statement ; "Mumbai is a city in India." Such a meticulous thinking.. beginners like me will be very happy with this..
Very much understandable way of teaching...Appreciate your effort sir
Excellent! I am a beginner and this tutorial helps me a lot.
Thanks a lot sir....First time i got a clear idea about VBA
Even the highest rated udemy courses can't match your level of teaching sir. U are the best, sir.
Your online classes are really good and understanding
Perfect Tutorial, very nice way of teaching.
what an amazing teacher! so clear.
@abhishektiwari2643
2 жыл бұрын
Yes
Thanks for providing valuable videos.
Fantastic tutorial, step by step....
Best teacher... Thanks a lot sir
Terima Kasih banyak, tutorialnya sangat mudah untuk di mengerti
very nice video very helpful and easy understand
I have been trying to understand VBA for a long time. But always failed because of the videos got to complex for me... But this series is very good. I am leaning new things now every day
Excellent i can understand easily😁and simple way
Day1 for vba. Thanks for the videos..
good collection and good information ..
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"
Nice Tutorial that is naturally good.
This is the best macro tutorial
Very useful tutorials
Olá, sou do Brasil, achei a sua aula excelente. Achei este formato de tela interativa, qual é a ferramenta que vocês usam?
It was great to see ur videos. Can u please give one class for odbc connections in excel how it works
Excellent teaching style.
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
Oh my god Sonu Nigam also teaches Excel
@jeetpranav2304
7 ай бұрын
Excel hua maddham VBA jalne laga
Sir you are simply great
I understood everything in first go.. nicely done and explained. Can you please explain cell referencing hierarchical wise.??
Best teacher.guide
you are great i congratulate do more for world .
This man is my god.
Oh my god this macro thing is a magic!
Thanks you so much brother!
Super Super explaining. Thank you
Good presentation. However if you could add ppt 1 ,2,3 etc that would be great to learn it better for new learners to have the continuation
Excellent❤
Very articulately taught
Thanks from Turkiye
GREAT SIR.
Nice .....Great helpful.. Sir
Good Efforts.
Excellent sir....
Thanks very much sir 🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏
Vvv nice my dear Please zoom monitor screen sir thanks a lot Love to you more from my side
Thanks a lot sir 🙏
Awesome..😍😘
Thank you Sir for your valuable videos. Requested to show how to create an UDF to Bold any text or numbers. Thank you Sir.
Beautiful...
Is there a way to set one of the reference values in the cells function to a variable? In python if you have an array, you can do something like this. array1 = [1,2,3,4,5] b = 0 while(b print(array1[b]) b = b + 1 Is it possible to do something similar with the cells function? So something like MsgBox(cells(1&b))....I keep trying it and it is not working for me...
awsome thank you
Woo sir awsome
Please post a video on how to use different functions..
Thank you for the viideo, can you make a video on how to use VBA in access and link folder
Thank you Pavan
Great sir
i like the array method where you can simply put bracket instead writing the range
good one sir
VERY GOOD
I do not know if this comment will get across to the lecturer. I was thinking if you have any website or a link where we can practice exercises to VBA coding. Thank you.
Thankyou 😊
Hello sir Great presentation Actually I am a teacher And I want to learn vba coding then how can I start ? Plz give me suggestions
Brilliant.
life saviour
please make a tutorial for javascript
Simple super
thanks
very nice
Dear sir kindly your all video upload by number episode. Its easy ways learning that wich thing is 1st or other is 2nd
hi sir I work in stock market.I want to automate my excels to pull the data.how can I?
Thanks😊
Good way
Thnk you sir..
What is the difference in assigning a value using “.value=“ and directly “=“ ??
Hey I have a very simple Excel VB project to add a macro. Can you Help me?
Fantastic, Sir is it possible to merge the dynamic ranges, as the Syntax is Range("A3:C6") I want to make this 3 and 6 dynamic and to be replaced with i which is dynamic in nature or in other words how to merge every nth An to Cn ranges.....
hello sir , i am your big fan and i am also learn excel like you. i need your help . i have a one query can you help me.
Great tutorial! I didn't get why is Range("a1") the most common way of accessing ranges, [a1].value seems so much simpler and doesn't use strings
@abongchuy2076
4 жыл бұрын
I agree!
@alankarpattekar3640
4 жыл бұрын
I think when we use Range() there are various methods associated with "Range" like range.copy, range.delete, range.borders, etc. So it can be more flexibly used. Thats what i think please check out.
Thank you
Is there a macro to set a flow of cursor movement.
THANKS SIR
Thanks, Sir
Thanks a lot for your nice presentation. here i have a question. in some cases you used .vaue but not for all. could you please explain the use of "value".
@priyanth123mohan
6 жыл бұрын
Hi For a particular cell use .value and for a range like a1-a10 in this case no need to use .value 07:54 u can see the difference for range c1-c10 and a2-a10 .value is not reqrd
@flotin9743
5 жыл бұрын
I was able to use without the ".value" in both cases in my code... very nice
Hi, can u please let me know why you used Range (a1) for a single cell, couldn't we use cells (1,1)? Range shouldn't be used for taking more than 1 cell?
@alankarpattekar3640
4 жыл бұрын
Range can be used for more alloting values to more than 1 cell : eg : Range("A1:A12).value="Jakarta". If you want to allot the value "Jakarta" using cells() function , you have to use a macro. Usually cell() function is used to allot value to a single cell. For allocation to multiple cells use a macro
Very Nice