Excel VBA - Record a Macro | Range Selection-Static vs Dynamic
Вставка
- Опубліковано 15 вер 2024
- Excel VBA - Record a Macro | Range Selection-Static vs Dynamic
===========VIDEO COURSE============================
✅ Mastering Excel Video Course
www.innozant.c...
✅ Mastering Power BI Video Course
www.innozant.c...
✅ Mastering VBA Video Course
www.innozant.c...
✅ Mastering SQL Video Course
www.innozant.c...
Visit - innozant.com
=====================================================
===========HYBRID CLASSES============================
✅ आरंभ EXCEL | सक्षम Analytics | निपुण Analytics
✅ Database Training(SQL , PL\SQL , Oracle Developer)
✅ Mastering Data Science
Visit - innozant.com
====================================================
Videos in a Sequence -Basic to Advanced EXCEL
Basic Excel- • Basic Excel-The Learni...
Advanced Excel Sorting and Filter- • Advanced Excel Sorting...
Subtotal TTC and Data Validation- • Excel Subtotal TTC and...
Excel What if Analysis- • Excel What if Analysis
Excel Array and Sumproduct- • Excel Array & Sumprodu...
Excel Lookup Functions- • Excel Lookup Functions...
Excel Pivot Tables- • Excel Pivot Tables
Excel Power Pivot- • Excel Power Pivot
Excel Power Query- • Excel Power Query
Excel Chart and Infographics- • Excel Chart and Infogr...
Excel Dashboard & Reports- • Excel Dashboard & Reports
Value add-ons Playlist
ProQuest-Check Point- • Excel ProQuest-Check P...
Career Guide:सिफर से सिखर तक - • Career Guide-सिफर से श...
StudsTalk -The Journey begins- • StudsTalk-The Journey ...
QUIZ Sunday- • EXCEL MIS QUIZ SUNDAY
Excel Tips and Tricks- • Excel Tips & Tricks
MIS Interview Cracker- • MIS Interview Cracker
MIS Job Live Interview :Based on Real Incident- • MIS JOB Live Interview...
Excel Maharaj- • EXCEL MAHARAJ - For Ex...
Microsoft Powerpoint- • Microsoft Powerpoint
Microsoft Word- • Microsoft Word
Office 365- • Office 365
Google Sheets- • Google Sheets
Microsoft Outlook- • Microsoft Outlook
Power BI- • Power BI
Excel VBA- • Excel VBA Macro
TezXL Jata Shorts- • #shorts | जो TRIM के ब...
Announcements- • Announcements
Website - "www.innozant.com"
Let's Connect:
Instagram ► / innozantinfotech
Facebook ► / innozantinfotech
Telegram►t.me/innozanti...
#innozant#excelvba #excelvbamacro
#vbainhindi #excelvbatutorial
Dear sir, you Are fabulous, I haven't no words to say more, You are Great and one of the Best UA-camr Chanal of the Era ❤❤❤ salute to you
Thank you so much 😀 Rohit
Your 1 video i am daily watching 😎your teaching style is good and your smile 😊
Thanks
Fully clear 😀 how to record a dynamic macro. Thanks a lot my learning of VBA again started. Actually I was waiting of this video from last 1 month. But please don't delay to uploading next video of VBA . its my humble request to you. Thanks Dil se ❤️
Thanks Shubham👍❤️
Thank you sir, you are our inspiration and ray of hope
Thanks
Bahot wait kra diya sir ...tarsa diya tha..wait krra tha kab aaygi next video..
Wow sir superb video very well explain 🙏🏻🙏🏻🙏🏻. Good night
Thank You sir for making our work easy.
Sir plz post 3 to 4 videos in a week🥺.....and thank u for your motivation 😍
Lack of time is issue dear due to other responsibilities
@@Innozant sir I sent you a mail regarding calculating time gap if time is given in UTC format I also shared a sheet naming (manifest pending xlxs) plz sir solve my problem & plz reply to mee
Sir,
Mere pass daily ik sheet download hoti hai humare dashboard se. Phir daily ik jaisa work kerna hota hai, jaise b coloum mein numeric data hota hai jo 12 number se jyada hota hai to usko theek kerna hota hai, poree sheet ko trim aur proper case mein kerna hota hai. Jis ke liye mujhe dikkat hoti hai main column inset krke trim aur proper ka formula laga ke ker ya huun . iske liye koi aisa option hai ki poore sheet trim aur proper case mein ho jaye.
@@prashanttyagi1156 bhai 1 tarika hai jisse jitna bhi sheets ho ya jo kuch bhi kisi ko bhi 1 second mein proper,lower,upper and trim ye sab kar sakte hai ....
Pehle to thank you so much Sir 👏. Kaise ho Sir aap?
Aaj bahut dino ke baad aapke darshan huye. Aapke videos dekh ke bahut kuch sikh liya or bhi sikh rahe hai.
Outlook se micro ke jariye mail kaise send karte hai vo bhi alag alag client ko iske upar bhi 1 video banao plz
mazaak nahi, isse better kisi ne nahi samjhaya, THANK YOU
Thanks dear
Sirrr aap sabse alag hai
Thanks Ritesh ji
Excellent basic learning of vba macro
Thanks Suresh Ji
Thank you so much sir for uploading this video 🙏🙏
Thanks Rahul
Sir last was best 😭😭😭😭😭😭😭😭😭😭😭. Because of last scene for me. 😭😭😭😭😭😭😭.
Thank you sir for all Excel video's. ❤️❤️❤️❤️❤️❤️
Thanks dear.keep learning
thanks you so much sir please share more video VBA playlist
Sir very very thank you...
Thanks jha ji
Sir I pls need a answer regarding this vedio can you pls answer???
Isme aapne dynamic macro ke liye jo ctrl + shift + down aero key kaha he select karna he wo selection kab karna he???
nice content
Thank you sir
u r the boss
Sir dynamic matlab kitni bhi baar data change ho like kam ya jada to ye sabpe kaam karega marco right????
Waiting for next video
Hi sir please share video dynamic record vba for formulas like v look up
I want to learn complete VBA Macro. Can you please upload a complete video on VBA Macro ao i can learn it easily and in one go. Really appreciate your work Sir🤍
I request is heard but in one go not possible you to give at least a week to understand each video.
Sir good pefomar
Thanks a lot sir ❤️🙏
Thanks sir
Hello sir first of all good mrning to u nd i m big fan of u .Your way of teaching is very uniqe thats what bring me here .sir how i can get a entry level MIS job i have knowledge of excel and advanced excel please helpe sir
Thanks..if you are confident in advanced Excel kindly prepare your cv based on mis reporting jobs and start applying for Entry level jobs also start learning SQL. And other tools
Hi sir. Your way of teaching is awesome👏. Can we talk your online classes sir
Take *
Yes Sanjay kindly connect us for upcoming batches details or you may visit Innozant website
sir
i wanna make a dashboard by using pivot and record a macro but it always shows a error
❤❤❤❤ thank you so much
Sir plz assist, 2 ya uss sy ziada excel files pr kaisy run kr skty hai macros.
Superb sir
sir please share real world project end to end of power bi
🙏🏼🙏🏼
Amazing video
Thanks Shalu..Keep Learning ♥️ and revise learned topic on regular interval
Thank you ❤
Sir
Agar ek workbook mai alag sheet hai matlab ki agar alag department wise ek hi report banana hai to kya ek 3 sheet select karna padega kya ?
Super
Babbaal sir🙏
Thanks Arjun
Hello Dear,
I am trying to fix my macro with dynamic range but facing issues. Can I please contact you
Room No.
Classes Roll No.
6C(1-15) = 15
Kya 15 ko automatically calculate kar sakte hain?
Please sir solve it.
I am also learned VBA code
Good 👍♥️
How to faxible selection
Sir ji 🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏
Sir power bi ka series thoda jaldi bnayiye sir
Sir aapke bharose jee rha hu, thoda jaldi bna dijiye
Thanks...Dear kam time milta hai due to other responsibilities isliye slow aa rhe hain video's
Sir plz make more videos on power bi
Sure dear..
Sir data validation ki list mai blank cell ko hatane ka tarika bataye
Question sahi se type kariye
Data validation me upper right corner per dekhiye....koi check box hoga blank cell ke liye
Pawan ko answer kariye Jin logon ne topic padh liya hai wo log..👍♥️
Sir Ji me aapse or Aapki video se motivate ho ke Excel Sikh raha hu. Agar mujhe Excel ke base pe job milegi to me aapse milna chahuga. 🙏🙏
Phir to hum sure milenge kyuki apne yadi quit nhi kiya aur seekhte rhe to bhale hi time lag jaye but achi job jaroor milegi apko...Milenge hum 👍❤️
@@Innozant Thanks sir Ji, 👍
Please make more video sir
👍❤️
Superb video sir
Macro ka use pivot bnane aur uske sathnl formula main kar sakte hai
Haan ..kar skte h
Can we record and use macro on pivot tables
yes but I recommend you to create it through proper vba code not recording
Nice 👌👌❤️
Sir please post more videos of VBA and macro ..
Sure dear
sir VBA ki video upload kr dijiye
Hi sir,
I need guide., To make macro, i am too near to make, but have one query, I need to contact with you.. if you can, kindly help me sir..
Great Sir
Thanks Abhishek ji
@@Innozant Your welcome sir🙂🙂🙂
Sri practice file kaha milegi
Sir,
How we make macro there is blank row or column in data..
Soon you may able to see
Sir please upload the next video 🙏
👍❤️
🙏🙏
Koi Faida Nhi Macro Record karka Macro enable ma Save karka Excel Band Kiya uska Baad Next day New Raw Data Mela Ab wo Macro nhi Ho raha ha
Sir mis excutive job ke liye kya interview english mein hota hai
Ha
Yes and no both are...and it depends and vary frok organization to organisation
But apko comm skills par utna hi mehnat karna hai jitna technical skills par
No words just amg
Thanks Suraj ji
Sir
Mein Mastering excel video course liya hain (21 July) ,agar mujhe koi query hoti hai to kaise resolve kar sakta (aap tak kaise share kar sakta hun)
@innozantofficial telegram id hai use sir direct handle karte hain saath hi monthly Doubt session attend kar sakte hain aap,For more information contact Team Innozant
@@Innozant thank you 😊
Send me full series of vba automation video
It is in process..please follow VBA automation playlist for the same
macro recording samjha nahi aati hai sir..
Bahot easy hai thora sa brain chalana hai......😊
@@Altaf_Alam sheet ko Krna sheet ke ander nahi
@@mayurrajude VBA code bahut hi easy hai
Yadi aap JavaScript shikhe hai to VBA code sikhana bahut hi easy hai
Aur JavaScript nahi shikhe hai phir kar sakte hai but starting me aapko thoda problem ho sakta hai
Esme only aapko property method aur eske syntax ko yad rakhna hai
@@mayurrajude kya matlab ?🤔
Good Altaf
Do reply sir pls …. mai bahut bure data me fasa hu regarding to Importrange
Kya issue aa raha hai.
Kindly share on @innozantofficial telegram id
❤️❤️❤️❤️
Sir Macro me pivot table nahi lag rahi
Kya issue btaiye
application.onkey method ke bare main bataiye sir..
Personal macro ka shortcut key kaise banaye vba se please bataiye
Saare questions ke answers mil rhe honge ..in sequence course upload hoga dear..have patience
@@Innozant Sure sir,
I am waiting
1st view sir ❤️❤️💯🔥
Thanks Altaf..Keep learning..aap students ke comment par respond karte hai ye apke positive aur knowledge spreading attitude ko show karta hai..Good job ..keep exploring
👌🏻👌🏻👌🏻👌🏻👍🏻👍🏻👍🏻👍🏻👍🏻👍🏻
Again only one word is there for your video that is,
Supercalifragilisticexpialidocious😁
Ek hi dikkat h bs video ane me 1 month lag rha h 😑
Hahahaha.. Thanks..aayega dear
1004 error a gaya.. Kyu ki mere text number format me the..
Sir, Macro को और अधिक describe करे, ऑफिस use में कैसे ले इसे l मेरे साथ बहुत परेसानी आती है ऑफिस में work करते समय, report बनाते समय, बहुत समय lag, जाता है, दिनभर का processing data को consolidate करके, pivot table लगाकर रोज report बनानी पड़ती है, कृपया मार्गदर्शन करे l Macro Record करने में please apki help चाहिए l दूसरा problem है कि, morning मे सबको Allocation होती है सभी processors को data, सबका नाम रहता उसमे, और बहुत सी columns भी होती है, उसमे से सिर्फ अपने नाम का data filter लगाकर copy paste करना पड़ता अलग sheet पर, फिर vendor wise कुल कितने bills मिले हैं process करने के लिए उसके लिए countif formula लगाना पड़ता है, फिर एक दो comulns भी जोड़ना पड़ता है, उसमे voucher number लिखने के लिए, इतना सारा काम रोज रोज same way मे करना पड़ता है, गधा जैसे, कृपया मार्गदर्शन करे l I want to become expert, An Pro Excel Operator, so need to be your attention please help me sir please 🌹राधे राधे 🌹ARK 🔥🏹हमेसा हंसते मुस्कुराते रहिये l
Please sir
🙏
Thanks
Videos aaane me bhut time lag rha h...
Yes duebto lack of time
ye log bus aise hi bolte hai jab aap subscriptions le loge to ghanta nahi samjh me ayega
Number do apna
Chandan ji lagta hai first time channel visit kiya hai apne Innozant,Pehli baat maine aaj tak Subscription ke liye kbhi channel par nhi bola hai ,dusri baat Complete course in sequence step by step premium content FREE me padhya hai jo koi nhi padhata,Ek baar dhnage videos playlis dekhne,Na apko subscription lene ki jarurat hai na ek rupye apne kharch karne ki aur aap seekh nhi ache se knowledge gain krenge wo bhi bina ek Paisa lgaye is baat ki bhi guarantee.
Keep Learning..Keep Exploring.
Apko statment jayaj hai ..Thagaye hue insaan lag rahe hain aap..😊♥️
Sir.. aachha shikhate hai.. usme koi 2 baat nahi.. Inka paid version lena Purta tension na lo..
Aspki baat sun kr bhut dukh huaa innozent pr bhut hi shandar videos h .....sir ne bhut hard work kiya Jo videos me dikhta h...
Hello dear, God bless your efforts.
I am a totally newbie vba learner.
I come to play with that code and have a simple enquiry.
How could i amend this code so that i can return all generated workbooks, inside a folder by which the code is run.
Thanks a lot
Sub test()
Dim rg As Range, i As Long, wb As Workbook
Dim vNames As Variant, v As Variant
Set rg = Workbooks("All raw data.csv").Worksheets("All raw data").UsedRange
'get unique names
With CreateObject("Scripting.Dictionary")
For i = 2 To rg.Rows.Count
.Item(rg.Cells(i, 1).Value) = Empty
Next i
vNames = .keys
End With
For Each v In vNames
ThisWorkbook.Worksheets("Sheet1").Copy
Set wb = ActiveWorkbook
wb.SaveAs v, 51
rg.AutoFilter 1, v
rg.Offset(1).Columns("A").SpecialCells(xlCellTypeVisible).Copy wb.Worksheets(1).Cells(2, 1)
rg.Offset(1).Columns("U").SpecialCells(xlCellTypeVisible).Copy wb.Worksheets(1).Cells(2, 2)
rg.Offset(1).Columns("Q").SpecialCells(xlCellTypeVisible).Copy wb.Worksheets(1).Cells(2, 3)
wb.Save
Next v
End Sub
You just need to run this script and you will get the desired result ,If you are asking me to explain the code then unable to explain here as you need to raise a query on @innozantofficial telegram id
Thank you so much sir 🙏
Thanks dear
Thank you 🙏