Thank you so much for your kind words and encouragement! 😊 I’m thrilled you found the tutorial practical and relevant to real-world problems. If there are any specific challenges you'd like me to tackle in future videos, feel free to share. Your feedback means a lot!
Awesome tutorial on name ranges. I love dynamic name ranges. LRow = ws.range("E" & Rows.Count).end(xlup).row Why do you reference worksheet in the code line above? ....... range("A" & ws.Rows.count) ....
I must have missed this comment. I apologize. I have explained about it in this post. stackoverflow.com/questions/11169445/find-last-used-cell-in-excel-vba/11169920#11169920
Another great tutorial. Excellent solutions to real world app problems. Congrats!.
Thank you so much for your kind words and encouragement! 😊 I’m thrilled you found the tutorial practical and relevant to real-world problems. If there are any specific challenges you'd like me to tackle in future videos, feel free to share. Your feedback means a lot!
شكرا لك احسن شرح
مرحباً بك :)
Excellent!
Question: Can you set the name of a range as a variable (Dim) and use the variable in the code?
Yes you can. For example Set rng = Sheets("Sheet1").Range("A1:A10") and then you can use it as Msgbox rng.Address or rng.Whatever
Awesome tutorial on name ranges. I love dynamic name ranges.
LRow = ws.range("E" & Rows.Count).end(xlup).row
Why do you reference worksheet in the code line above?
....... range("A" & ws.Rows.count) ....
I must have missed this comment. I apologize. I have explained about it in this post.
stackoverflow.com/questions/11169445/find-last-used-cell-in-excel-vba/11169920#11169920
Helpful content. 👍
Audio has too much echo.
Painful to listen to.
Thank you for your feedback. Yes, initially I struggled a lot with no proper recording equipment. I hope it is much better in recent videos?