omg. I'm not getting much sleep. I keep learning more from you and instead of fixing the basic stuff I have written, I am thinking of other things I can do! Thank you :-)
In Spanish-language there's not channel like this one. Great, you have a nice voice, even my native language is Spanish, i get all you explain. I just founded you. Congratulations "Desde américa Latina, Nicaragua. Saludos"
VBA allows to specify ranges using the short notation with square brackets instead of the Range() or Cells() property. For instance 'Range("A1").Value' can be written in short as '[A1].Value'. This is also true when using areas, for instance [A2:C2].Value = "2nd", and named ranges such at [LastOne].Value = "10th".
I am one of those who believe that there is always something to learn. And this has just been verified once again. Although I have been writing VBA code for years, I have never used the shortcut "?" in the immediate window because I used to write the entire debug.print command. So thank you very much Leila for this
Hi Mehdi. I'm glad you found something new here. Actually I was also not aware of the "?" method for the longest time after I started to use VBA. It made me very happy when I discovered it :)
Hi Leila, for the history this is an old (legacy) command coming from old versions of Basic. If my memory is good I used it with gwbasic for more then 25 years ago :)
Hello Leila, I've been working now through some of your great tutorials here and now I really have to make you a big compliment. Thanks sooooo much for the great work you a doing here, it's really a great performance. Your tutorials are very well structured and very easy to understand and extremely helpful. Thank You :-)
@@LeilaGharani i started watching your tutorials 3 days back and the more i am diving in, the more i am learning "FAST" and more i am liking your WAY of teaching. Full of confidence, command, knowledge and patience. GREAT WORK and inspiring achievements. Getting convinced to join your online tutorials paid version. I hope they will be even better.
Thanks Leila, You just cleared up a lot of confusion I had about vba range referencing. I am very grateful......and YES, I like what I see but someone already subscribed before me! :)
This is really great Leila. Love your presentation and excellent explanations. It is very well thought out. You make it easy to understand. When Mike Girvin is following your videos, you know you are among the great. Thank you so much for sharing.
buenos principios excel, tienes un gran poder de enseñar, hay personas que creen que solo se debe enseñar lo mas astral, pero los principios de excel son excelentes, te felicito
Oh Wow, solved my problem in a few easy minutes, well explained. I wish my school teachers, College Tutors etc, were like this. Thanks for giving me some enjoyment with learning :) I used this in Excel VBA "A1", "A" & lRow, Where lRow was the last row number. Cheers :)
Thursday is my favorite day! I was already wating for your new video. This is great, will practice this as you instructed. I want to be prepared for when the VBA course finally comes out.
Thanks a lot Madam, very inspiring, illuminating, impressive, inquisitive & revealing, . Explanation is superb, very articulate. On behalf of all my Excel learner friends A BIG SALUTE TO MY BELOVED BEAUTIFUL TEACHER.
Thanks Mike - yes...... not easy to find a good class ;)) In the past week I've been locked up working on finalizing the course. I haven't had a chance to watch your videos, but I've added them all to my list. Have some catching up to do once I get out of here...
Thank you for reaching out to me!!! But I am sorry, antiksh... I was making a joke... I already know about Wise Owl. I feature the Wise Owl channel and Leila's channel at the excelisfun Channel home page : ) I was making a joke that I should take Leila's class. But really it is no joke - she is so amazing at teaching and marketing and making videos : ) Go Amazing Online Excel Team, including you antiksh!!!
Awesome video. I think this should be the first video to watch for any one beginning to learn macros like me. I've spent hours trying to figure out how to refer cells in different scenarios. Can you also mention how to refer to variable ranges? Eg Range from A1 to Ai where "i" is a result of another formula or loop counter etc. Thanks for making a video on this topic though.
thanks, the many ways of getting ranges as part of a row or column is very helpful. all this is similar in openOffice too but they appear to use : and , differently and to also use ;. in VBA i never access activesheet or activerange or selection, I actually pass a range or ranges to the code as in the following which i really have no error checking. Function rms(ByVal Target As Range) As Double 'root mean squared. quadratic mean Dim Cell As Range Dim summand As Double Dim tot As Integer tot = 0 summand = 0# For Each Cell In Target.Cells If IsNumeric(Cell) Then tot = tot + 1 summand = summand + Cell ^ 2 End If Next Cell rms = Math.Sqr(summand / tot) End Function
I like how you teach. In fact, I'm enrolled in your Power Query Course. I'd assumed that you also have a Excel VBA course right? I'd like to learn macros.
Just figured out my error: I named my module Cells which started this whole mess! (I left my question for anyone else's benefit)>>>>Thanks for the work you put into this video Leila, quick question: When I tried to use your second example: cells(1,1)="1st" it gave me an error: Compile error: Expected variable or procedure, not module. It's like vba isnt recognizing that expression because it's not even suggesting anything when I type the "cells(" part....... Thanks for any help.
Very informative , but I have a request if you can show us how to merge cells than contains same value with option for Excel user to select the cells range as an input on dailog box Thanks
Hi @Leila , how would you select two ranges and select them together ? E.g. Header should be fixed Range (First Range) and second range would be from active cell range.
Get access to the full Excel VBA course here 👉 www.xelplus.com/course/excel-vba-excel-macros/
omg. I'm not getting much sleep. I keep learning more from you and instead of fixing the basic stuff I have written, I am thinking of other things I can do! Thank you :-)
Leila has the best Excel tutorials/videos by far! I did two of her courses and she is simply the best instructor!
Wow, thank you!
In Spanish-language there's not channel like this one. Great, you have a nice voice, even my native language is Spanish, i get all you explain. I just founded you. Congratulations "Desde américa Latina, Nicaragua. Saludos"
Thank you! 😃
GOD bless you Mrs Leila, Thanks a lot for your tutorials
VBA allows to specify ranges using the short notation with square brackets instead of the Range() or Cells() property. For instance 'Range("A1").Value' can be written in short as '[A1].Value'. This is also true when using areas, for instance [A2:C2].Value = "2nd", and named ranges such at [LastOne].Value = "10th".
Hi Leila, Really really impressive explanation of cell referencing. This is the best video explaining the cell references.
Thank you.
I think I started to understand VBA with you thank you so much Ms. Leila
New to VBA. Most useful video I have seen. Thank you.
I'm very happy to hear that Lawrence. Glad you like the video.
I am one of those who believe that there is always something to learn. And this has just been verified once again. Although I have been writing VBA code for years, I have never used the shortcut "?" in the immediate window because I used to write the entire debug.print command. So thank you very much Leila for this
Hi Mehdi. I'm glad you found something new here. Actually I was also not aware of the "?" method for the longest time after I started to use VBA. It made me very happy when I discovered it :)
Hi Leila, for the history this is an old (legacy) command coming from old versions of Basic. If my memory is good I used it with gwbasic for more then 25 years ago :)
Thanks for the info :)
Hats off to Leila ! . I learns lot from your videos.
Glad to hear that
Used this techniq and solved a issue for which i am looking for a solution in long time. Keep rocking😎👏✌
Hello Leila, I've been working now through some of your great tutorials here and now I really have to make you a big compliment.
Thanks sooooo much for the great work you a doing here, it's really a great performance.
Your tutorials are very well structured and very easy to understand and extremely helpful. Thank You :-)
was looking for multiple range syntax and found it here after looking on various sites. Thank you
Lady Leila, I LOVE YOU for making this wonderful tutorial. Excellent TEACHER.. knowing the art of MAKING UNDERSTAND.
Thanks a lot.
I'm very happy to hear this Aamir! Glad you like the videos.
@@LeilaGharani i started watching your tutorials 3 days back and the more i am diving in, the more i am learning "FAST" and more i am liking your WAY of teaching. Full of confidence, command, knowledge and patience. GREAT WORK and inspiring achievements. Getting convinced to join your online tutorials paid version. I hope they will be even better.
You're creative, so I've decided to outdo you in this field. تحية لك من المغرب
impressive teaching ability , right pace and right details . subscribed !.
Much appreciated!
I did enroll in Udemy in Leila VBA course and I learned immensely. Thanks
You explain concepts very well and it is easy to follow. Thanks
Glad you think so!
Excellent video. You are great instructor, and the video is top-notch in clarity.
Excellent video and narration! Thank you!
Thank you! This video gave me an excellent explanation about cells and ranges referencing.
Glad it was helpful!
Thanks Leila,
You just cleared up a lot of confusion I had about vba range referencing. I am very grateful......and YES, I like what I see but someone already subscribed before me! :)
Glad it was helpful!
Leila you r awesome and nicely explains with smile and simple way. Thank u
So Clear Explanation....!!! Makes understanding simple.! :) thank you So Much !! :)
You are welcome!
I like the way you explain. Really awesome!!! Thankyou.
Clear, concise, and informative. Thank you.
This is really great Leila. Love your presentation and excellent explanations. It is very well thought out. You make it easy to understand. When Mike Girvin is following your videos, you know you are among the great. Thank you so much for sharing.
buenos principios excel, tienes un gran poder de enseñar, hay personas que creen que solo se debe enseñar lo mas astral, pero los principios de excel son excelentes, te felicito
Thank you Mario. Glad you like the video.
Thankd leila
Back to our happy day
Waiting for the end to learn about the course
Good luck ur highness
You're welcome.
It's happy Thursday :) Wish you a great rest of the day.
Thank you for teaching the basics!!!!
Thanks Leila, nice preparation for the upcoming course
You're welcome Cobus & thank you.
Such a smart, beautiful woman. Iran makes great things. Thank you for these videos.
@Elegant Fowl Pls
Explanation is in very nice & systemic way, Thanks
Thanks and welcome
Outstanding presentation. Thank you.
Cells.Columns.Autofit is lovely.
Leila gets 🌟 🌟 🌟 🌟 🌟
Very clear, understandable. Great way to learn Excel m
I'm glad to hear that.
Amazing 👏 that was full comparhansive explanation 👏
I appreciate that efforts from your side
This is was very helpful
My pleasure 😊
You are an awesome teacher.
Very useful lecturer Leila , Thank you so much.
You're very welcome Sanjay.
Oh Wow, solved my problem in a few easy minutes, well explained.
I wish my school teachers, College Tutors etc, were like this.
Thanks for giving me some enjoyment with learning :)
I used this in Excel VBA "A1", "A" & lRow,
Where lRow was the last row number.
Cheers :)
Glad it helped!
This was very helpful
You are the best😊😊👌👌👌
Excellent way of explaining.. Thanks.
Very nice presentation
Look forward to your course
This is fantastic. I will be taking the course at some point in the future.
Great! I hope you'll like it.
Unbeatable knowledge Leila.. thanks..
Great lecture, easy to follow.
Brilliant. I like your videos Leila. Thanks a million.
Thank you! I’m glad to hear that.
excellent review!
So well explained, as always!
Thank You Leila for your time and cool video !
My pleasure Jossi. Glad you like the video.
This is a good hobby
Very good video. I liked the way you did the drag and drop with the named range...pretty cool way to do that.
Glad you like that :)
Very much insightful.. No need to refer to any other material as far as Range object though VBA..👍👍👍
so well explained. Thank you
Thursday is my favorite day! I was already wating for your new video. This is great, will practice this as you instructed. I want to be prepared for when the VBA course finally comes out.
Mine too! Great. Practice is always good :))
Hello Leila the lesson to day was very clear. Keep it up.
Thank you Solomon. Will do my best :)
Thank you.
really awesome,,i acquired a lot of knowledge in your video.
Fantastic, Thanks.
Superb! Excellent!Thank YOU!
You are very welcome!
Thanks a lot Madam, very inspiring, illuminating, impressive, inquisitive & revealing, . Explanation is superb, very articulate. On behalf of all my Excel learner friends A BIG SALUTE TO MY BELOVED BEAUTIFUL TEACHER.
Thank you very much Gopala for the kind words and for your support. I am glad you're enjoying the VBA series so far :)
Awesome VBA Referencing video!!!! Quote Happy Fun : )
ExcelIsFun You should learn VBA as well😁
Yes but where could I find a good class!?!?! ; )
Thanks Mike - yes...... not easy to find a good class ;))
In the past week I've been locked up working on finalizing the course. I haven't had a chance to watch your videos, but I've added them all to my list. Have some catching up to do once I get out of here...
ExcelIsFun Try Wise Owl on youtube👍🏻
Thank you for reaching out to me!!! But I am sorry, antiksh... I was making a joke... I already know about Wise Owl. I feature the Wise Owl channel and Leila's channel at the excelisfun Channel home page : ) I was making a joke that I should take Leila's class. But really it is no joke - she is so amazing at teaching and marketing and making videos : ) Go Amazing Online Excel Team, including you antiksh!!!
Thank You So Mutch.
Awesome video. I think this should be the first video to watch for any one beginning to learn macros like me. I've spent hours trying to figure out how to refer cells in different scenarios.
Can you also mention how to refer to variable ranges? Eg Range from A1 to Ai where "i" is a result of another formula or loop counter etc.
Thanks for making a video on this topic though.
So clear Leila! Thank you!
Great job, Leila!
Thank you! 😄
بهترین استادی👏👏👏
She is the best
thank you ; its useful
Thanks Leila. Very Interesting. Some practice and will wait for the next one :)
You're welcome John. Agree - practice is always good :)
Thanks a lot💕💕💕💕💕
Very clear and useful!
Bundle of Thanks Mam Nice Video
You're very welcome Khalid. Thank you for your support.
thank you very much
Thanks a lot, very clear!
Thanks ma'am 😊 your videos are quite helpful
You're welcome Sami. Glad to hear that :)
Leila Gharani Ma'am do u have videos on data validation, concatenation ?
Useful video, Thanks
You are Divine. Demi God of Excel
Thanks a lot Leila.
Thanks!
thanks, the many ways of getting ranges as part of a row or column is very helpful. all this is similar in openOffice too but they appear to use : and , differently and to also use ;.
in VBA i never access activesheet or activerange or selection, I actually pass a range or ranges to the code as in the following which i really have no error checking.
Function rms(ByVal Target As Range) As Double
'root mean squared. quadratic mean
Dim Cell As Range
Dim summand As Double
Dim tot As Integer
tot = 0
summand = 0#
For Each Cell In Target.Cells
If IsNumeric(Cell) Then
tot = tot + 1
summand = summand + Cell ^ 2
End If
Next Cell
rms = Math.Sqr(summand / tot)
End Function
i also use parallel ranges, either rows or columns 1 wide, but have to not use for each
U r the best
Very true
Nice video
you are great, really it interesting video
Thank you! 😃
@@LeilaGharani
@@LeilaGharani dear I follow most your videos really it was very interesting and my level is progressing but can you guide me to advanced book in vba
Thanks for the video ma'am.
You're very welcome Mohit.
Really awesome. Thanks.
you are good.
its good really
I like how you teach. In fact, I'm enrolled in your Power Query Course. I'd assumed that you also have a Excel VBA course right? I'd like to learn macros.
thank you!
Thanks
Just figured out my error: I named my module Cells which started this whole mess! (I left my question for anyone else's benefit)>>>>Thanks for the work you put into this video Leila, quick question: When I tried to use your second example: cells(1,1)="1st" it gave me an error: Compile error: Expected variable or procedure, not module. It's like vba isnt recognizing that expression because it's not even suggesting anything when I type the "cells(" part....... Thanks for any help.
I wish more women would use/support your channel. 😊
Me too! We need more women here!
Can you make video on cutting length optimisation
Superb videos
Thank you Vinod! Glad you like the videos.
Very informative , but I have a request if you can show us how to merge cells than contains same value with option for Excel user to select the cells range as an input on dailog box
Thanks
thanks thanks thanks
Hi @Leila , how would you select two ranges and select them together ?
E.g. Header should be fixed Range (First Range) and second range would be from active cell range.