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

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

#Excel #ExcelTips #ExcelTutorial

[PauleenMendoza-xm]

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

[JoaoPedro-piee]

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

[sisterniveditaschool]

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

[masumshahin]

great to have such learning sessions in youtube

[manishkumarchd]

Very very clear understandable video with example. Great..

[netarmster]

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

[ravig]

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 But, the content copied in A20 was from A1 (including the heading and the title). Can you please clarify?

[vijaysahal]

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

[gauravsemwal]

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

[tasfia]

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

[nischalpadi]

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

[csamantdhruvanagesh]

sir sorry to disturb you
I would like to ask you a question
As shown in your code, you have written before every line
Instead of that Can't we just 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?

[femmeindienne]

Range ("B2", = True Why this code is throwing error? please check!

[georgywordrighter]

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?