I find it really amazing that Indians are good in explaining things clearly. Easy to understand. Straight forward. Awesome. Big hands from Philippines.
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.
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.
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.
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
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.
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.
What if we want numbers in equal intervals in the range C1:C10? E.g. here we gave "tutorials" for all, but if we want 2, 4, 6 and so on...how would we get that?
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 < len(array1)): 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...
Awesome teaching method. The only issue I faced so far is "if I press F8" on keyboard, step into is not working. I need to use mouse pointer to click the same in the debug menue. Can anyone help?
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".
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
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.....
Hi sir , I want to ask something , You have told in this video that (cells(1,2).value = "India" ) if we will type this in program then India will be type in row number 1st and column number 2nd . right , but it is not working in excel 2007 , sir please make me sure it will work in excel 2007 or not
What is the distinction between these two approaches? [b5].Value= 70 and Range("a1").Value = "Mumbai" [c1:c10]= "Tutorials" and Range("a2:a10") = "Jakarta" As if they're both doing the same thing and [b.5].Value and [c1:c10] are simple to remember and write, but why Range(" ") is preferred?
You have a got a point. The Range(" ") is widely known and familiar just from Excel cell A1 notation (Column A, B, C,.....; Rows 1, 2, 3, ............). It is descriptive and concise. The [B5] referencing is just a short cut, less intuitive!
Hi,how to create or name a range using vb or macro? For example I have more than 100x individual ranges that I want to name or add it on name manager. For example I want cells(1,1) named as "One", then cells(1,2) as "Two" and so on until 500. I cant do it manually, I want quick. Please help. -More power to you channel
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?
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
please kindly Advise: how to write in the cells put the column value through vba userform. example A1=1001,A2=140,A3=ABCD, A4=MM/DD/YYYY B1=1002, same as above mentioned A2 A3 A4.............etc... can you explain as well add,update & delete button. I hope you.
Hi sir i work in excel sheet in which i put my name from cell A2 to A201 and date in cell B2 to B201so is there any way to populate these two data automatically using VBA code? Thanks in advance
Hello sir , Your online class very useful for me and understanding also but I want to learn more so can I learn if u suggest me any class who tell me perfect way step by step I understand but when I do ...when m doing I get mistake and vba editing when m run it ..it's not working I need to practice more so can u plz tell me a proper class name who practice in data ..we work on data so may be it's more helpful for me to understand...
![Felix "Unfair" | [Stray Kids : SKZ-PLAYER]](http://i.ytimg.com/vi/Oswujxm2Ag0/mqdefault.jpg)
Get Certified in Excel VBA:bit.ly/41fWeVP
Use coupon "RUclips12" 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 RUclips, who have made my programming journey easier.
Respect from Nepali in Germany.
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.
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.
Hello sir, when did you leave RSS?
Good explanation. Never been this far watching someone explain VBA.
Sir, I dont have any word to describe your teaching method, Hats off......
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
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 :-)
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.
It was great to learn that I could simply reference between "[ ]". This way is faster and cleaner! Very nice
Same here Flavio H. Campos. Yeah, I agree.
I liked your statement ; "Mumbai is a city in India." Such a meticulous thinking..
beginners like me will be very happy with this..
What a clarity you have and the way you teach is amazing.. I love your videos and your style.. :))
Very much understandable way of teaching...Appreciate your effort sir
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.
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
Excellent. Explained in a very easy and simple way. Thank you
Excellent! I am a beginner and this tutorial helps me a lot.
Perfect Tutorial, very nice way of teaching.
what an amazing teacher! so clear.
Yes
Your online classes are really good and understanding
Love watching your video! Thank you so much!! These all are really beneficial!
Great presentation! Thank you very much for your effort.
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
Very very.. excellent explanation brother..! 🎉🎉
Excellent, I really appreciate your effort, Thanks A Ton Again Mr. Pavan Lalwani
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"
Best teacher... Thanks a lot sir
This is the best macro tutorial
Oh my god Sonu Nigam also teaches Excel
Excel hua maddham
VBA jalne laga
Olá, sou do Brasil, achei a sua aula excelente.
Achei este formato de tela interativa, qual é a ferramenta que vocês usam?
Excellent teaching style.
Fantastic tutorial, step by step....
Nice Tutorial that is naturally good.
Nice .....Great helpful.. Sir
Day1 for vba. Thanks for the videos..
I understood everything in first go.. nicely done and explained. Can you please explain cell referencing hierarchical wise.??
Terima Kasih banyak, tutorialnya sangat mudah untuk di mengerti
Sir you are simply great
you are great i congratulate do more for world .
Excellent i can understand easily😁and simple way
Thank you Sir for your valuable videos. Requested to show how to create an UDF to Bold any text or numbers. Thank you Sir.
good collection and good information ..
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.
This man is my god.
Very articulately taught
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
It was great to see ur videos. Can u please give one class for odbc connections in excel how it works
Thanks for providing valuable videos.
Super Super explaining. Thank you
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
I agree!
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.
Best teacher.guide
Thanks very much sir
🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏
Awesome..😍😘
Very useful tutorials
What if we want numbers in equal intervals in the range C1:C10?
E.g. here we gave "tutorials" for all, but if we want 2, 4, 6 and so on...how would we get that?
Use loop
Hi Pavan, is it necessary that the module name has an underscore (_)?
Vvv nice my dear
Please zoom monitor screen sir thanks a lot
Love to you more from my side
Do you have some cheat sheet thing for your lectures ??
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 < len(array1)):
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...
Excellent❤
Thanks from Turkiye
Hey I have a very simple Excel VB project to add a macro. Can you Help me?
Please can you tell why you write ". Value" when macro can work without that? Like that worked in your last line example of this video?
Awesome teaching method. The only issue I faced so far is "if I press F8" on keyboard, step into is not working. I need to use mouse pointer to click the same in the debug menue. Can anyone help?
i like the array method where you can simply put bracket instead writing the range
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".
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
I was able to use without the ".value" in both cases in my code... very nice
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.....
Hi sir ,
I want to ask something , You have told in this video that (cells(1,2).value = "India" ) if we will type this in program then India will be type in row number 1st and column number 2nd . right , but it is not working in excel 2007 , sir please make me sure it will work in excel 2007 or not
Thanks a lot sir 🙏
What is the distinction between these two approaches?
[b5].Value= 70 and Range("a1").Value = "Mumbai"
[c1:c10]= "Tutorials" and Range("a2:a10") = "Jakarta"
As if they're both doing the same thing and [b.5].Value and [c1:c10] are simple to remember and write, but why Range(" ") is preferred?
You have a got a point. The Range(" ") is widely known and familiar just from Excel cell A1 notation (Column A, B, C,.....; Rows 1, 2, 3, ............). It is descriptive and concise. The [B5] referencing is just a short cut, less intuitive!
Hi,how to create or name a range using vb or macro? For example I have more than 100x individual ranges that I want to name or add it on name manager. For example I want cells(1,1) named as "One", then cells(1,2) as "Two" and so on until 500.
I cant do it manually, I want quick.
Please help. -More power to you channel
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?
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
Excellent sir....
Is there a macro to set a flow of cursor movement.
Dear sir kindly your all video upload by number episode. Its easy ways learning that wich thing is 1st or other is 2nd
Good Efforts.
Thanks you so much brother!
How enter value in a cell from different language? For example Japanese text doesn't appear as it is.
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
Please post a video on how to use different functions..
please kindly Advise:
how to write in the cells put the column value through vba userform. example A1=1001,A2=140,A3=ABCD, A4=MM/DD/YYYY
B1=1002, same as above mentioned A2 A3 A4.............etc...
can you explain as well add,update & delete button. I hope you.
hi sir I work in stock market.I want to automate my excels to pull the data.how can I?
Macro usage understood but Y do v write code when v can actually directly write/perform task in the excel? 🙄
Hi sir i work in excel sheet in which i put my name from cell A2 to A201 and date in cell B2 to B201so is there any way to populate these two data automatically using VBA code?
Thanks in advance
can you correct this code, if wrong
Cells(Sheet4.Rows.Count, "B").End(x1UP).Offset(1, 0).Select
Really nice presentation, but initialise option is not coming , the. What should I choose.
Got the tab
Oh my god this macro thing is a magic!
GREAT SIR.
I need ur all vba video can u tell me where I got these
www.tutorialspoint.com/excel_vba_online_training/index.asp
Are you from Indonesia?
Beautiful...
Sir actually what is the difference between 2nd method and 4th method almost same right??
What is the difference in assigning a value using “.value=“ and directly “=“ ??
Hello sir ,
Your online class very useful for me and understanding also but I want to learn more so can I learn if u suggest me any class who tell me perfect way step by step I understand but when I do ...when m doing I get mistake and vba editing when m run it ..it's not working I need to practice more so can u plz tell me a proper class name who practice in data ..we work on data so may be it's more helpful for me to understand...
If you can convert your logic into structure, you can depend on stackoverflow to get your question answered.
notification shows that macros are disabled, i am not able enable macros, any suggestions..?
Thank you for the viideo, can you make a video on how to use VBA in access and link folder
I tried to do cell referencing but it working for first active cell not for second active cell. Plz help here
Thank you Pavan