Free Excel VBA Course #8 - Working with Cells and Ranges using VBA in Excel (Select, Copy, Format)

[@PauleenMendoza-x8m]

I love how systematic you teach your students. Your channel is a hidden gem.

[@JoaoPedro-pi9ee]

You are very good at teaching! Natural talent! Congratulations I am enjoying very much the course! Greetings from Brazil

[@masumshahin9313]

great to have such learning sessions in youtube

[@sisterniveditaschool]

I feel everyone watching the video should like it ..... In a token of appreciation of the effort the youtuber has given here ....

[@moncia9835]

Great video! 😃 thank you so much!!!

[@ravig853]

Hi Mr Bansal. Your effort is really appreciated and your explanations are very clear and understandable. But, I have a doubt sir. You coded Range ("A3").Currentregion.copy.Range("A20"). But, the content copied in A20 was from A1 (including the heading and the title). Can you please clarify?

[@moncia9835]

Very useful! 👏 thank you

[@netarmster6297]

Wow Your Explain very clear and Details...so amazing... Hope you create more video lesson that related some important field of manager...any lesson just like "How to create Accounting & tax Management system, Employee Management System, Inventory System, Automatically Invoice..." Because i really want to learn about that. Much Thanks 🙏🙏🙏

[@manishkumarchd]

Very very clear understandable video with example. Great..

[@rohitverma905]

I really enjoyed this video so much

[@vijaysahal4556]

Hi Bansal sir you are amazing I have some query can you make a An Arrey dyamansation with ds move same project row +column plz

[@MuhammadTayyab-vr9sf]

Really grateful from Pakistan!

[@musolutionsofficial2995]

Super Work Appreciate From Pakistan

[@gauravsemwal2246]

Sir if we want to select value above one crore in numerical(more than 9999999) and write VBA code for that then what will write in vba code please explain sir.

[@akashdeshmukh116]

To write in first sheet ,do we always need to add that statement before each line..@9:14

[@adarshkumar-rb4iw]

Amazing 🙌

[@mathsfreak964]

Happy Teacher's day sir🎉🎉

[@margad-erdeneboldbaatar4704]

Thanks so much.

[@6c45samantdhruvanagesh9]

sir sorry to disturb you I would like to ask you a question As shown in your code, you have written before every line Worksheets("Sheet1")....... Instead of that Can't we just write[Worksheets("Sheet1").Select] and then everything below that as you shown i tried that and it is working even if you are on any other worksheet . it will be more easy than writting worksheet before every line. Can we do that?

[@tasfia5904]

At @8:37 when you add worksheets ("sheet1"), I tried to do it but it shows the invalid property error, not sure why, I have double-checked the spelling and everything. The problem seems to be with that worksheet line though..

[@nischalpadi4499]

Hey Sumit! @17:04 You mean B3 to C15 right? and not B15 to C15

[@trumpexcel]

Yeah.. my bad.. should have been B3 and not B15

[@aymanebziou2656]

Thankyou

[@venkevijay]

great

[@femmeindienne2276]

Range ("B2", Range("B2").End(xlDown).Font.Italic = True Why this code is throwing error? please check!

[@pipaliyarahul2343]

Hi, I think you forgot to add ) after End(xlDown)

[@sharadgupta2007]

Look like andrew gloud

[@georgywordrighter5662]

I don't understand why this would be useful. If you were say compiling a list of films and ratings why use VBA when it would be far quicker to simply type it into the cell directly in the table. You end up putting in the same data into VBA plus all the associated coding? Or am I missing something obvious?

[@nischalpadi4499]

It's just an example he is showing us on how to operate things