Introduction to Excel VBA HINDI - Series 5/5

Last series in hindi to make you vba champion.
learn how to use copy and paste and what is the code to select entire table.
Don't forget to watch from beginning if you need to understand every logic used in the video.
if you like to give donation please visit www.excelvbalover.com and click on donation link.
If you are new to channel and want to learn from beginning please see below playlists:-
Excel VBA Introduction hindi
• Excel VBA - INTRODUCTI...
Excel VBA Variable Hindi
• Excel VBA - VARIABLES ...
Excel VBA Loops Hindi
• EXCEL VBA- LOOPS HINDI
Excel VBA Collection loops hindi
• EXCEL VBA -COLLECTION ...
Excel VBA Arrays hindi
• Excel VBA - ARRAYS HINDI
Excel VBA Functions Hindi
• EXCEL VBA FUNCTIONS- H...
Excel VBA UserForms Hindi
• Excel VBA - USERFORMS ...
Excel VBA Events File Forms Hindi
• EXCEL VBA FORMS EVENTS...
Excel VBA Dictionary in Hindi
• EXCEL VBA DICTIONARY -...
If you like to join my online personal live training or purchase them please visit www.excelvbalover.com and avail special discounts.
You can email me as well at [e-mail] if you have questions

[@SubodhKumar-di8jc]

It is made interesting for beginners to learn excel vbs here as you taught Step by step and work hard. Thanks for your good effort.

[@AjayKumarparmar]

Thank you

[@sagarvaikar5524]

you are best best best best teacher of vba thank you teacher

[@vipulchaudhari4437]

शिखाने की टेकनिक......बहुत बढिया....Thank U

[@bhushantere5757]

It is good start to learn excel VBA... love the technique the way you teach with the help of Macro editor...

[@gauravkaushik2363]

Thanks sir.... Introduction series ki sabhi video bahut achhi se samjh aayi or bahut kuch seekhne ko mila... Tab se pata ni chal rha tha ki kanha se VBA coding seekhu but ab right path or aa gya hu or aap ki bajah se mere excel VBA seekhne ka safar suru ho chuka hai bas ab tum mujhe lead karo aapki krapa rhi to I hope mai ek achha VBA developer banunga... Thanks sir

[@kumarraghav9345]

The way u teach is great sir & lecture k chalte chalte mere dimag me jo questions aatey h aap us sab k answers deyte rehtey ho . Without asking u any questions u give its answer that is amazing sir. Thanks a lot sir , thank u so much . Your videos are very helpful for me.

[@RajYadav-ih6mx]

Project was very knowledgeable! Thanks sir for ur hardwork. Whole introduction series was very intresting & I repeated it once again and got new thing to learn.

[@gautamgautam1113]

Best tutorial

[@AjayKumarparmar]

welcome

[@anand6802]

You are God for us.... I'm learning alot from you and the way you explain is unbelievable. Thank you ajay

[@AjayKumarparmar]

I loved your comment. So much respect and love it has for me. Thanks again for believing in me..

[@study4734]

Series achhi hai Sir. kaafi baatein samajh aayi.

[@vikassinghjayara510]

Hi Ajay Sir, I have started to learn Excel VBA and this introduction series is very informative and knowledgeable. I really like this series and now I will learn the next part - Variables. Thanks for making this series for the beginners like me. Love you sir😍 God bless you 🙏

[@sarupvichare6208]

Introduction series is very useful for beginners..aftr watching intro series I have started to practicing on offset, ctrl+pagedwn etc and also I have search few more codes and I am daily practicing on it. I will start other series in couple of days.. Thank you so much..

[@aryadin]

Very well explained. Thanks a lot. YOu are too good, much better than foreign English tutors

[@safatimesnews24]

i am highly grateful for the VBA series, videos have been really helpful... thank you very much..

[@YamanKumar09]

Very explicitly explain...one of the best tutorials I have ever come across, Thank you so much.

[@shoaibrehman9988]

Hi Ajay your efforts are priceless. You have done a tremendous job to spread your knowledge to us. Thank you very much

[@enemieskiller5537]

I left my VBA Classes after watching your Videos Thanks a lot dear

[@deepishani]

Great sir, you are amazing. I could not learn from my teacher as much in detail as you teaching. Thank you very much, thanks a lot

[@ashoksahu9546]

Really sir bahot aachha padhate ho aap. Any one can understand easily.

[@AjayKumarparmar]

Ji thanks... Click bahut less hai.. Aapne dekha hoga.. Please support. Share the channel with your friends and colleagues.

[@ptejwani]

I am very much impressed. Keep it up. God bless you.

[@sumandas485]

Awesome sir.. by the end of video no 3, i tried the last project without knowing the topic no 5. I'm a beginner and I'm pumped by this. Looking forward to learn more.

[@AjayKumarparmar]

Suman... All the best. Pump up the channel also. It's your channel. U know what I mean...

[@sumandas485]

yes sir... sure

[@hemantpatel7002]

Thanks you have provided very nice lecture for beginners like me. I am not a professional computer programmer but only a maths teacher but interested to know programming in Excel. …👍🙏👍

[@AjayKumarparmar]

You can visit www.ajayparmartutor.com

[@Pratapbrazil]

really It's just an amusing feeling , the level of dedication/experience/knowledge and skills you having and how beautifully you are able to describe all those tiny aspects about coding thing is just Incredible... I guess people may think that I am exaggerating...but honestly I have seen many excel and VBA lectures but your Playlist is on TOP of all of those...... I really wish your channel get boomed like your skills are.... Have a good day... Ajay.

[@AjayKumarparmar]

Thank you thank you thank you.... So happy that you liked the series so much. Fantastic... Your each word means so much to me. Thank you again.

[@radheprajapati2036]

pawan Soni i hat's off Mr. ajay no words for him.... for his explanation teaching method outstanding......amazing

[@sonu2op747]

COMPLETED THE TASK.. HERE IS MY CODE THANK YOU SO MUCH SIR... Sub PRACTICE() Sheets("SHEET1").Select Cells(1, 1).Select Range(Selection, Selection.End(xlDown)).Select Range(Selection, Selection.End(xlToRight)).Select Selection.Copy Sheets("SHEET2").Select Cells(1, 1).Select ActiveSheet.Paste ActiveCell.End(xlDown).Select ActiveCell.Offset(1, 0).Select Sheets("v").Select Cells(1, 1).Select Range(Selection, Selection.End(xlDown)).Select Range(Selection, Selection.End(xlToRight)).Select Selection.Copy Sheets("SHEET2").Select ActiveSheet.Paste 'PLEASE CHANGE THE SHEET NAME AS YOUR PREFRENACE. End Sub

[@AjayKumarparmar]

Keep up the hard work

[@asifraini5190]

Really amazing and very helpful for those who wants to learn VBA..I m great fan of your teaching style..Thank u sir

[@SushilKumar-hd1mt]

All videos of this series are really helpful and amazing, easily understandable, its all credit goes to your style of teaching and explanation, really do explain is an art and you are the hero of this field, thanks a lot sir, once again.

[@naatslibrary7822]

I really enjoyed it from Pakistan...

[@deepakgupta3192]

His sir many thanks , complete series is great , I learnt so much seems end of so much confusion , my request please make vedio on macros - object , properties and methods . Many thanks

[@nazeeratp]

Ajay jee Aadaab, Aap ka yeh series bahut hi badhiya hai..... hum jaise (matlab jyada excell ka gyan naheen hai) phir bhi aap ka lecture hamein bahut fayedamand hua... aur mera ek sujhao hai ke aap video ke aakhir mein thodey problem ya programme apne se likhne ke liya dedeejiye to aur bhi achcha hoga... Dhanyawaad. Iss series ke baad hum aap ki kaunse videos follow kareyn...sir

[@jksunique2463]

You are great. Ajay Sir. After introduction series should have seen your VBA programming video. Please Sir reply. I have very obliged to your teaching manner.

[@gurdev3]

Very useful for begnners Great Lecture

[@easitaxetds8846]

Way of explanation is very good..

[@shaileshmayekar2495]

You are a great teacher 👍

[@pandurangjadhav8613]

Thanks sir.. very nice learning..

[@hafizurrahman9081]

So nice Sir.Its very helpful. thanks a lot for your tutorials.

[@nityanandapanda6291]

Very awesome series Sir. And also made systematically. Can u please publish a video an extension from here, i.e. How to copy data from identical range of sheets in the same workbook and compile in the 'master sheet' using offset ? It will be helpful for me and also for others.

[@vsrblr]

It was amazing, tons of thanks for your detailed explanation and made my life easy

[@Morden_Tecnology2012]

#you are great sir you are best teaching with example sir mere pass ek workbook hai jis me teem sheet hai is me sheet 3 me 2500 row our 10 column hai jis me 1st and 2nd column me no hai in me se kisi ek row ke data ko find ya filter karke sheet 2 Pe macro se serch box bana ke kaise automatic serch kar sakte hai (Puri ek Row ko jiski Print karni hai) advance filter se macro record se hota nahi cells and offset command bhai kam nahi kata

[@adirohila]

Really your video is very nice & you are excellent tutor.

[@Meditation5235]

Excellent Series with very easiest way. Thanks a lot!!!

[@AjayKumarparmar]

Welcome

[@akshaysehdev9929]

Your teaching techniques are too good and you are awsm Thank you so much sir.

[@mr.d1868]

You deserve so much likes, but only 1 like is possible in your channel

[@PankajKumar-re5xz]

Ur jabara fan sir Ur teaching style is great awesome. You gave me a way to me to learn vba Now i am not scared. After that which videos have i to watch

[@Colors-lifestyle]

It's very helpful I like the way of explanation 🥰🥰🥰

[@Nitin3mittal]

Sir you have really a explained very well. Please advice the sequence of your other Excel VBA playlists. You have already created many other playlists for VBA excel but I am confused to choose it's sequence. As I just learnt introduction and want to go in a sequence only, So please advice the sequence of playlists.

[@AftabAnsari-uq9ns]

Excellent Video

[@radheprajapati2036]

superb.... ur explanation is outstanding ......

[@sunnygupta2907]

maja aagaya sir ...thanks

[@sanojkumar8048]

So nice video sir.

[@subhajitbasak5863]

Sir very nice class ......

[@mohammedaltaf4877]

very good job

[@shanuansari2659]

You are Genius sir

[@manishjain9320]

Sir. Very nice lecture. Sir, I want to learn excel VBA completely and step by step. Please let me know which chapter of playlist should I choose now. I have already learn five introduction video.

[@bingodada9189]

Very good sir

[@rajeevsharma7026]

Nice plz dont stop in hindi

[@AjayKumarparmar]

Please bring hindi viewers Rajeev...

[@surajbagkar9792]

useful for freshers

[@RamnikChondigrarrc]

Wonderful I understand all Thanks

[@ShankarKumar-ch2hy]

Very good explanation sir.

[@sharadhatole1948]

Sir, I m subscriber for VBA excel hindi videos & I m learning lots from it, thx for it sir. Sir There is one problem for me How to increase text input limit in textbox up to large text up to 2-3 pages information.

[@ojas2020]

Amazing sir

[@rahulkashyap2704]

☺️ Thankyou ❣️ Sir ☺️ M ❣️ really ☺️ enjoying ❣️ it ☺️❣️

[@AjayKumarparmar]

Ok

[@surensingh6243]

Very good intro series..

[@AjayKumarparmar]

Shukria

[@rakeshmlearningentertainme6099]

Todyas introduction topice finish nice video sir all .

[@AjayKumarparmar]

Many many thanks

[@gujjenaut]

Thankyou Ajay Ji !!

[@kunalmendiratta5289]

Great Sir Ji

[@pankajsharma7233]

sir i have doubt as i execute the same code in this lecture in the sheet "white board" so why it wont be execute .

[@patidarramesh5298]

i m done it..!! aur last 2 videos me jo XLDOWN ki error thi wo solw ho gayi mene XLUP AND XLDOWN ke naam ke hi macro banaye hue the...... baad me mene wo macro rename kar diye to sab error chali gayi.... Thannks a lot.....

[@AjayKumarparmar]

Shabash

[@radheymaurya3655]

Sukriya Sir

[@vijaysahal4556]

👍🏻again 👍🏻👍🏻👍🏻👍🏻👍🏻💯

[@hasmukh19871]

Thank you very much sir, I really use full your video

[@AjayKumarparmar]

Great..

[@gagandeepsinghchhabra3638]

Hi ajay sir, i have just ended up with your VBA Introduction class (and it was amazing learned a lot from there). Could you please advise after class 5 (ended in VBA INTRODUCTION) now which playlist i need to check so that i can continue this after class 5. I am bit confused in this🙏🙏

[@bhaskarghosh5046]

Good work

[@joe21lester]

Awesome Sir, Thanks.

[@danveersingh9611]

Great

[@suvendubarik9074]

Hi Sir, In this chapter we are able to compile data from two sheets in another sheet. But, how can we pest below the remaining data it's not showing here. If, it's given in any other chapter please mention. Thank You Sir.

[@ashokkumarverma4387]

great knowledgeable

[@as35160]

Sir, in this series after reaching the blank cell how to write for sum the value of the column.

[@bapumote8921]

Thanks , very nice 👍

[@AjayKumarparmar]

Thanks again...

[@mindgame8232]

You are great sir

[@patidarramesh5298]

sir last video me bhi muje ek hi problem hui thi same proble ho rahi hai XL TO RIGHT/LEFT/UP ho raha hai par XLDOWN me hi error aa jati hai.. range("g1").select range(selection, selection.end(xldown)).select COMPILE ERROR expected function or variable pls help

[@RoshanKumar-mp4wg]

Hello Ajay Sir, Thanks for the video I want the active sheet name to be copied in column c under basics tab for reference so that I will get to know from which sheet the data was copied to merge how I can do that?

[@AjayKumarparmar]

Use VBA event... like workbook open or sheet activate. Track every information

[@Morden_Tecnology2012]

Greatest

[@Llb890]

your videos helpful

[@somanathbiswal6725]

Really superb

[@shaileshmayekar2495]

Hi Ajay can we put password to the vba codes we create? This series was fantastic.wish you all the very best.

[@AjayKumarparmar]

yes you can...in tools reference

[@robinssharma6622]

Super Sir Thank you so much for this video

[@sachinkashyap8763]

Sir meri starting aapki video ke sath bhut acchi haui hai And iss series ke baad mujhe Kon si series start karni hai plz bataye

[@AjayKumarparmar]

Check Playlist sequence in description

[@harryrawat2116]

Sir please mujhe ye bataye....aagar Mera range ( a1)hai or Mai chhahta hu ki (A1) se (A9) Tak ke saare cells mai date feel karna hai wo bhi serial by serial...like jaise agar cell (A1) ki value=Saturday 05/01/2019 hai or mujhe cell (B2) ki value= Sunday 06/01/2019 chiye to ksie change kar sakta hu mai

[@VishalT28]

Sir.. It's a wonderful introduction series. I have a question... Can I copy and bring data from another workbook..?

[@sachinkashyap8763]

Thank you so much sir

[@surajbagkar9792]

nice sir

[@amandeepkamboj859]

Good Morning Sir, I viewed complete series of introduction. Please tell me, After this which playlist/ series i have to start.

[@AjayKumarparmar]

Please check comment description

[@farooqafzal6126]

Nice...

[@MM-is5fl]

Hi Ajay, I have selected a range a1 to a35 but in between 3 to 4 cells is blank after 4 to 5 non blank cell, some cell gab 1 or 2 or 3. Which code is write for selecting the data, I have already try code range(selection, selection. End(xl down). Select but it is not working, it's only working one time. I have recorded a macro but macro recording the same code. Please suggest or share ur email ID, if possible.

[@reshrajthala9856]

superb sir thank u

[@AjayKumarparmar]

You're welcome

[@shoaibrehman9988]

In this playlist series 4 & 5 some issue after few minutes stuck can't play further pls check

[@neerajkumarpandey1180]

thanks

[@maheshbhosle9389]

Nice series as expected... But what if I have to copy data from different workbooks?????? Pls rpl

[@AjayKumarparmar]

Keep moving

[@prashant1513]

wow great sir. I really learn vba by your video.

[@mansoormushtaq2875]

Dear sir Please ye bataen next konsi series dekhni chahiey #Introduction to Variables HINDI# ????