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

Рет қаралды 34,378

4 жыл бұрын

In this video, I will show you how to work with cells and ranges using VBA in Excel.
Something that we will cover in the video would be:
-- How to select a cell using VBA
-- How to select a range using VBA
-- How to select till the end of the row/column using VBA (something similar to what happens when you use Control + Shift + Arrow keys
-- How to select and enter a value in the cell after the last filled cell
-- How to enter a date in a cell using VBA
-- How to copy the cell and paste in a different sheet using VBA
✅ Download File: bit.ly/vbacourse-8
☕ If you find my Excel videos useful and would like to support me, you can buy me a coffee - www.buymeacoffee.com/SumitB
Free Excel Course (Basic to Advanced) - trumpexcel.com/learn-excel/
Best Excel Books: trumpexcel.com/best-excel-books/
Subscribe to get awesome Excel Tips every week: kzfaq.info...
#Excel #ExcelTips #ExcelTutorial

Пікірлер: 29

@user-co8yv6eo6j 3 ай бұрын

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

@sisterniveditaschool 3 жыл бұрын

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

@JoaoPedro-pi9ee 2 жыл бұрын

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

@masumshahin9313 9 ай бұрын

great to have such learning sessions in youtube

@manishkumarchd 3 жыл бұрын

Very very clear understandable video with example. Great..

@rohitverma905 3 жыл бұрын

I really enjoyed this video so much

@MuhammadTayyab-vr9sf 3 жыл бұрын

Really grateful from Pakistan!

@musolutionsofficial2995 4 жыл бұрын

Super Work Appreciate From Pakistan

@moncia9835 6 ай бұрын

Great video! 😃 thank you so much!!!

@moncia9835 5 ай бұрын

Very useful! 👏 thank you

@netarmster6297 4 жыл бұрын

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 🙏🙏🙏

@adarshkumar-rb4iw Жыл бұрын

Amazing 🙌

@margad-erdeneboldbaatar4704 2 жыл бұрын

Thanks so much.

@mathsfreak964 3 жыл бұрын

Happy Teacher's day sir🎉🎉

@aymanebziou2656 3 жыл бұрын

Thankyou

@venkevijay 3 жыл бұрын

great

@vijaysahal4556 4 жыл бұрын

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

@ravig853 3 жыл бұрын

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?

@akashdeshmukh116 4 жыл бұрын

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

@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.

@tasfia5904 3 жыл бұрын

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 4 жыл бұрын

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

@trumpexcel 4 жыл бұрын

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

@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?

@femmeindienne2276 2 жыл бұрын

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 3 жыл бұрын

Look like andrew gloud

@georgywordrighter5662 4 жыл бұрын

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 4 жыл бұрын

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