Master Excel MACROS & VBA in ONLY 1 HOUR!
In this Microsoft Excel Tutorial you will learn Excel Macros & VBA Programming inside 1 Hour! DOWNLOAD THE PRACTICE WORKBOOKS & FREE MACROS & VBA CHEAT SHEET: www.myexcelonline.com/107-160...
I am using Excel 2016 in this VBA Excel Programming & Macro tutorial but you can also apply what I teach in Excel 2010, Excel 2013, Excel 2019 and Excel Mac versions 2011 and 2016 (as well as the latest Office 365 version).
In this Excel Macro & VBA Programming tutorial for beginners you will learn how to:
👉 Record MACROS & Write VBA Code within 1 HOUR!
👉 AUTOMATE repetitive & boring tasks with a single press of a button that will SAVE YOU Time & Money!
👉 Save and share your Macros!
👉 Debug and step into your VBA code
DOWNLOAD THE PRACTICE WORKBOOKS & FREE MACROS & VBA CHEAT SHEET: www.myexcelonline.com/107-160...
JUMP TO AN EXCEL FORMULA & FUNCTION TUTORIAL WITHIN THIS VIDEO:
0:00:00 - Introduction
09:00 - Record a Macro
21:40 - Modify a Macro using the VBA Editor
27:30 - Save a Macro Enabled Workbook
29:30 - Insert a Worksheet & Rename it using a Macro
43:25 - Add a Macro to the Quick Access Toolbar
45:45 - How to add a Button to run a Macro
50:03 - Step into & debug your VBA code
------------
🔥 OUR BEST EXCEL RESOURCES 🔥
👨🏫 Get 30+ Excel & Office Courses & support for ONLY $1💵 (all levels covered)
Learn Formulas, Macros, VBA, Pivot Tables, Power Query, Power Pivot, Power BI, Charts, Financial Modeling, Dashboards, Word, PowerPoint, Outlook, Access, OneNote, Teams, Project, PowerApps, PowerAutomate, Visio, Forms & MORE!
Join Now for ONLY $1 (LIMITED TIME OFFER) 👉 www.myexcelonline.com/107-186...
📚 Download Our Free 101 Excel Tips & Tricks E-Book:
Download for FREE 👉www.myexcelonline.com/101-exc...
💻 Access 1,000+ Free Excel & Office tutorials over at our award-winning blog:
Access for FREE 👉www.myexcelonline.com/107-3.html
📚Get All Our 101 Excel E-Book series on Formulas, Macros & Pivot Tables:
www.myexcelonline.com/107-59....
📚101 Most Popular Excel Formulas Paperback on Amazon:
www.amazon.com/dp/1700300911
📚101 Ready To Use Excel Macros Paperback on Amazon:
www.amazon.com/dp/1700729675
📚101 Best Excel Tips & Tricks Paperback on Amazon:
www.amazon.com/101-Best-Excel...
👷 Excel Consulting Services:
www.myexcelonline.com/microso...
💻 Looking for more Microsoft Excel & Office tutorials? Check out our playlist below:
www.youtube.com/@MyExcelOnlin...
------------
Feel free to comment and ask questions about this Microsoft Excel tutorial below and we will get back to you with the answer ASAP!
If you enjoyed the video, please give a thumbs up, comment, share.
Do not forget to SUBSCRIBE to this channel to get our new Microsoft Excel tutorials delivered straight to you each week! Thank You :)
Cheers,
JOHN MICHALOUDIS
Chief Inspirational Officer & Microsoft MVP
www.myexcelonline.com/
❤️ Let’s connect on social ❤️
LinkedIn: / johnmichaloudis
Instagram: / myexcelonline
Pinterest: / pins
Facebook: / myexcelonline
Twitter: / myexcelonline
#MyExcelOnline #MsExcel #Macros #VBA
Пікірлер: 318
Been trying to learn VBA from KZread. Watched tons of videos but this one actually was awesome. Thank you ❤️
@MyExcelOnline
2 жыл бұрын
That's great! Thanks for the positive feedback!
this is amazing thanks! I watched this video for 5min(with fast forwarding) and then went ahead to build a simple VBA macro for work! I thought it's gonna take me much longer...Awesome information, thanks!
@MyExcelOnline
5 жыл бұрын
Hey FW, Glad you liked this Excel Macros & VBA tutorial!
@vinodhkumar4878
2 жыл бұрын
Sir can u help me I have one file that I need different format to make macro ....plz hlp me sir
I found this extremely Helpful. I am going for a new job and they asked if I knew macros after this session I feel confident that I can do this job to the fullest
@MyExcelOnline
5 жыл бұрын
WOW that is awesome Holley! Let us know how you get on with the job interview and I am sure that you will do well :)
Thank you John & Kyle. It was really amazing; Mr. Kyle did an awesome introduction to Macros and VBA. God bless you both.
@MyExcelOnline
2 жыл бұрын
Glad you enjoyed it!
@ahmednavivwala1707
8 ай бұрын
5:37
Such a simple and professional way to understand Macros, you're awesome guys. BEST Luck to you :)
@MyExcelOnline
4 жыл бұрын
Thanks for your comment and feel free to share this with your friends and colleagues :)
I think It’s not easy to simplify this , but you did it so well. Thank you very much.
@MyExcelOnline
3 жыл бұрын
You are welcome
@ahmednavivwala1707
8 ай бұрын
5:46
jump straight to 4:10 to skip the orga stuff at the beginning. Great Video. Thanks a mil.
@rafie004
5 жыл бұрын
4:24 to be exact but thanks!
@MyExcelOnline
5 жыл бұрын
Hey Jamal, Glad you liked this Excel Macros & VBA tutorial!
This is gold. very helpful thank you
@MyExcelOnline
5 жыл бұрын
You are welcome Chris and make sure to check out our other awesome Excel tutorials on our KZread channel and over at www.myexcelonline.com/blog/
Nice introduction to macros and VBA code. I understood the coding itself but I often had trouble understanding looping. Your explanation of the "do while" looping code was easy to understand and now I feel confident I could use it in a similar circumstance. Thanks !!
@MyExcelOnline
4 жыл бұрын
We are glad that you were able to learn the "do while" looping and become more confident in Excel VBA!
@ahmednavivwala1707
8 ай бұрын
5:25
You are a great teacher. Thanks for the training
@MyExcelOnline
5 жыл бұрын
I hope you learned a lot of new Excel & VBA tips!
the way you teach makes it so easy to understand , thank you .
@MyExcelOnline
2 жыл бұрын
You are welcome! Thanks for the compliment!
💻Access 1,000+ Microsoft Excel video training tutorials covering Formulas, Macros, VBA, Pivot Tables, Power Query, Power Pivot, Power BI, Charts, Financial Modeling, Dashboards, Word, PowerPoint, Outlook, Access, OneNote, Teams & MORE! JOIN TODAY TO ADVANCE YOUR EXCEL SKILLS 👉 www.myexcelonline.com/107-42.html
A wowsome webinar!
@MyExcelOnline
6 жыл бұрын
Glad you enjoyed this Excel Macros & VBA tutorial Sandeep! Feel free to share with your friends :) Cheers, John
Hi ,I went though a lot of video in you tube and found your explanation is very simplest way, Thank you Kyle.
@MyExcelOnline
2 жыл бұрын
Oh, thank you! We try hard to make videos easy for everyone to understand.
Excellent course. Very clear and organized.
@MyExcelOnline
4 жыл бұрын
Thanks Karen and I hope that Macros & VBA are much easier to you now!
Thank you indeed for this video, very helpful.
@MyExcelOnline
5 жыл бұрын
I'm glad you enjoyed this Macros & VBA tutorial Mauricio!
Wow, I never thought I would get excited about coding but this is really cool.
@MyExcelOnline
5 жыл бұрын
Welcome to the exciting world of coding Roger :)
Wow! one of the clearest explanations of VBA code. Thanks a lot
@MyExcelOnline
2 жыл бұрын
Glad it was helpful! Thanks for watching.
Why didnt i find you guys earlier.... Blessing in disguise... I learnt so much from your channel and amazing training video... Totally nerdy ;)
@MyExcelOnline
4 жыл бұрын
That’s awesome to hear VC! Feel free to share our channel with your friends 👍
Well done Kyle, thanks!
@MyExcelOnline
6 жыл бұрын
Glad you enjoyed this Brenda! Cheers, John
@TheBadrinath
4 жыл бұрын
Hi
1st time looking into Macros. Wasn't sure which video to start with. Glad I started with the right one! Excellent work! Thank you.
@MyExcelOnline
Жыл бұрын
Glad it was helpful!
I used to hate coding before, Aftr watching this detailed explanation I started liking coding ,hope I can master in VBA
@MyExcelOnline
2 жыл бұрын
Practice makes perfect Rachel, keep on Excelling!
Great Job Buddy . Extremely helpful..
@MyExcelOnline
2 жыл бұрын
Glad to hear it!
Loved it!!!!!
@MyExcelOnline
5 жыл бұрын
I am glad you enjoyed our Macros & VBA tutorial Thato!
EASY ....ITS FLOWS ... YOUB ARE INDEED AN EXCEL TEACHING ANGEL
@MyExcelOnline
4 жыл бұрын
Thank you for your nice comments Idowu!
Thanks for the informatory videos...well explained :)
@MyExcelOnline
4 жыл бұрын
You are welcome 🙏
really thanks to god..i ve seen a lot video but your video i can understand very much better..really love u a lot a lot..big thumbs up from malaysia
@MyExcelOnline
4 жыл бұрын
You are most welcome and glad you learned how to use Macros & VBA to automate your Excel worksheets & reports!
clear so professional and awesome - great job bro.
@MyExcelOnline
Жыл бұрын
Thank you!
This is awesome!
@MyExcelOnline
6 жыл бұрын
Glad you enjoyed this Excel Macros & VBA tutorial for beginners! Cheers, John
I like this so much and it's one of my best videos on youtube
@MyExcelOnline
2 жыл бұрын
That's great! Thanks so much!
Man you are the best thank you for your efforts!
@MyExcelOnline
2 жыл бұрын
My pleasure! So glad you found this helpful!
I really liked this presentation easy to follow through
@MyExcelOnline
2 жыл бұрын
Glad you liked it.
Nice content . Nice presentation with clear workable english. Excellent trainer & his knowledge..
@MyExcelOnline
2 жыл бұрын
Glad you liked it
so wonderful to follow to master VBA and Macros
@MyExcelOnline
4 жыл бұрын
You are welcome Moses!
Thanks , Love this video
@MyExcelOnline
5 жыл бұрын
Im glad you enjoyed this Macros & VBA tutorial Siafa :)
very nice and much helpful in learning VB macros. Thank you so much..
@MyExcelOnline
Жыл бұрын
Most welcome! Thanks for watching!
Nice personality , clear and professional.
@MyExcelOnline
2 жыл бұрын
So nice of you. Thanks!
This is really good info. Thanks!
@MyExcelOnline
Жыл бұрын
Thank YOU for letting us know!
This is excellent material! Do you have the part 2 of this course on youtube please??
@MyExcelOnline
4 жыл бұрын
Hey Sitara, we have more VBA tutorials over at our Academy online course here: www.myexcelonline.com/academy/enroll-eg/
Beautiful. Thank you.
@MyExcelOnline
3 жыл бұрын
Our pleasure!
kyle you ROCK!
@MyExcelOnline
6 жыл бұрын
Glad you enjoyed this Excel Macros & VBA tutorial for beginners! Cheers, John
This guy is an AWESOME TEACHER!
@MyExcelOnline
7 ай бұрын
Thank you!
Thanks for the knowledge shared....
@MyExcelOnline
Жыл бұрын
Our pleasure! Glad you liked it!
thank you for this!!
@MyExcelOnline
4 жыл бұрын
You are most welcome Nasta!
Hi John, I would like to learn VBA macros more. Could you please share us more videos which is help us to learn VBA in depth.
@MyExcelOnline
3 жыл бұрын
Here we have 101 Macros for you: www.myexcelonline.com/blog/101-excel-macros-examples/
This is very useful, clear and very precise. Do you have other tutorials like this either in Python, R, Data Science, Data Analytics, ML, or SQL
@MyExcelOnline
3 жыл бұрын
Unfortunately we don’t have those specific courses at the moment
I have just found your site and this is exactly what I was looking for for sometime now. I consider myself an intermediate user of Excel but I want to improve my knowledge from a certified organisation such as yours. Please let me know if this online training offer is still in effect today. Thank you.
@MyExcelOnline
Жыл бұрын
Sure! Check out our website at myexcelonline.com as we have many different options under the Courses menu. Hope you find one helpful to you!
Thank you so much!!
@MyExcelOnline
2 жыл бұрын
You're welcome!
Thank you so much.
@MyExcelOnline
3 жыл бұрын
You are welcome
Good video, and I recommend watching at 1.25x speed.
@MyExcelOnline
5 жыл бұрын
Thanks for your feedback and that is a great tip!
@Youssiflagrosse
5 жыл бұрын
1.5 is fine too. I was dying... Thanks for the tip.
@ziadabdat6232
4 жыл бұрын
Thank you for the tips,
@naomilago
9 ай бұрын
I'm watching at 2x and it's fine now
Wow! that's great
@MyExcelOnline
Жыл бұрын
Thank you! Cheers!
Thanks you are good at it
@MyExcelOnline
2 жыл бұрын
Thanks! Glad you liked it!
thanks dude, now monthly work, will finish in 1 day
@MyExcelOnline
2 жыл бұрын
It’s possible with Macros & VBA!!!
Amazing teaching
@MyExcelOnline
3 жыл бұрын
Thank you!
You guys are GREAAAAAAAAAAAAAT
@MyExcelOnline
3 жыл бұрын
Thanks!
Thank you so much for the video. It was really helpful. I have a question, to ask you. If I have to copy a set of cells every day from a set of worksheets into a notepad and save that notepad datewise, is it possible to use macros or VBA? Please help.
@MyExcelOnline
2 жыл бұрын
You can create a filesystemobject and use the CreateTextFile method. Also, visit our blog for lots of tips: www.myexcelonline.com/blog/
Thank you do much!
@MyExcelOnline
2 жыл бұрын
You're welcome!
Hi, this is a good vba Page. I suggest these useful macros: Workbook route in title bar Workbook name in title bar Highlight active cell Highlight active row & column Color tabs - worksheets Uncolor tabs - worksheets Number to letters
@MyExcelOnline
2 жыл бұрын
Thanks for the tips! Those ARE good macros.
@MyExcelOnline
2 жыл бұрын
And check out our site for more macros: www.myexcelonline.com/137-42.html
don't really know the magic was there in the excel .Thanks a lot to let me know..really appreciate the video
@MyExcelOnline
3 жыл бұрын
You are very welcome. Excel IS magical! And really fun to use!
Hello, I want to watch this video once more before I sign up for the course. Please send me a link so I can download it and watch it. I'm 79 and it takes me longer to catch on to this stuff. Thank you for the great session. thanks, Jim
@MyExcelOnline
3 жыл бұрын
Hey Jim, unfortunate the video is not downloadable but you can watch it as many times as you like here 😀
It's extremely helpfull. If you show me how we can assign any job into among some employees by using vba. It will be more helpful for me
@MyExcelOnline
2 жыл бұрын
Hi! Thanks for the feedback. Check our blog at www.myexcelonline.com/blog
I find it best to try and write the logic longhand in comments within cells that I would like to see in my workbook. How do others visualize the processes that they envision for their workbooks?
@MyExcelOnline
4 жыл бұрын
Thats a great way of doing things Claude! Each person has their own unique way of doing things inside Excel so they can easily remember how to get to a result :)
This was a great webinar for introduction on Macros and VBA. Obviously no one can master it in 1hour, if that was the case everyone would 😂
@MyExcelOnline
3 жыл бұрын
You are correct! Hopefully it was enough to get you interested in VBA.
Nice video, I have learned new knowledge from the webinar. But the thing, this is only an introduction. lol
@MyExcelOnline
2 жыл бұрын
Great! Glad you now want to learn more. Check out our website and blog at www.myexcelonline.com/blog/ to learn even more!
so nice
@MyExcelOnline
5 жыл бұрын
Glad you liked this Excel Macros & VBA tutorial!
Hi the Video was too informative all i wanna ask is that if i want to for eg add a month July to my worksheet and then copy the july and paste till the end of the range and then i use the same macro in the other excel sheet where the is longer than this worksheet what can i do in order to get the data till the end of the range of the new excel worksheet
@MyExcelOnline
Жыл бұрын
Hi. Thanks for the question. Can you see the original range? If it ends in say Cell D50, just edit the D50 to the end of your new range (the cell with the end of where the July that you added is). If that doesn't answer your question, please respond in more detail.
Useful
@MyExcelOnline
2 жыл бұрын
Glad to hear that Mariann!
The concepts are shown so very clearly. I would lie to learn about VBA coding and macros to develop automated dashboards. Could you please guide me. Thank you !
@MyExcelOnline
2 жыл бұрын
We have a dashboard series AND a VBA series if you'd like to check them out.
@MyExcelOnline
2 жыл бұрын
kzread.info/dash/bejne/iGqWrqONdtqahto.html
@MyExcelOnline
2 жыл бұрын
Also, there's an intro to dashboards in this playlist, towards the bottom: kzread.info/dash/bejne/qHVmsMuSmarRl9Y.html
@MyExcelOnline
2 жыл бұрын
And if you don't find what you need there, please check out our blog: www.myexcelonline.com/blog/
Hi, I have a question: How can I create a dynamic pyramid chart that is horizontally and vertically segmented? In excel or power BI. Thanks a million.
@MyExcelOnline
2 жыл бұрын
Please check our blog and if you don't find the answer, feel free to contact us there. www.myexcelonline.com/blog/
Awesome ! Your former student Kyle !!
@MyExcelOnline
2 жыл бұрын
Hi Kyle! Glad to see you are still using Excel! Thanks for responding!
Thanks you very much blue men! 🎶im blue if i was green i was die🎶
@MyExcelOnline
2 жыл бұрын
HAHA! Thanks for watching.
Thanks for the video Can YOU please explain how to remain sheets using the VBA code when we want to rename each sheet a different name? I tried Activesheet.Name code after 1st sheet name but it gives error Do YOU guys have any video on that or anyone else can help?
@MyExcelOnline
2 жыл бұрын
Hi Wasay. Do you have a copy of the code you are trying? Sometimes it is found in Worksheets("name of sheet") . You can try that.
This ìs really greàt
@MyExcelOnline
2 жыл бұрын
Thank you!
when you are creating a macro to copy and paste value into another sheet, can you copy down or do you have to only go right to left?
@MyExcelOnline
3 жыл бұрын
You can copy whichever direction you like
Sir need your help about conditional formatting! I want to highlight the row whenever I type "QC" in that row, and not all the cells in that row, want to highlight only those cells in that row which are filled (not empty). please guide!
@MyExcelOnline
4 жыл бұрын
Please look at this tutorial which will help you out: www.myexcelonline.com/blog/conditional-format-a-cells-value/
thanks! Loud and clear
@MyExcelOnline
3 жыл бұрын
You're welcome!
Very helpful, but definitely watch at 1.25x speed, otherwise it's gonna be a long watch
@MyExcelOnline
4 жыл бұрын
Good tip!
hi there, is it possible to download data from SAP into Excel using Excel VBA?
@MyExcelOnline
5 жыл бұрын
It is best to do this using Power BI Desktop to do that. Go to: Get Data > More > In the search box type in SAP.
Hello, is this course still offer those bonuses mentioned? I'm interested, but I don't know if I will still get the same value for the course. Please let me know. Thanks!
@MyExcelOnline
Жыл бұрын
Hey Janet yes it does! Just go to our website myexcelonline.com and drop us an email there. We will get you setup asap! 💚
New to macros and looking to export data from sheet 1 to sheet 2, but only pulling through certain columns, and changing the data in those columns when it lands in sheet 2. Any ideas?
@MyExcelOnline
Жыл бұрын
It might be better for you to use Power Query, as PQ is perfect for data transformations.
Nice video & really help full .I have one question .Is it possible to build a code which already build in MATHLAB and now covert those build up code in MS Excel ? Thanks in advanced
@MyExcelOnline
3 жыл бұрын
Unfortunately there is no conversion tool but you can apply the same principles in VBA
nice
@MyExcelOnline
2 жыл бұрын
Thanks
I'd learn Excel from a zombie . I was awesome. Thanks a lot!
@MyExcelOnline
5 жыл бұрын
You are welcome Gau!
@SL-uq1sx
4 жыл бұрын
Hehe
What about VBA enabled workbook? My workbook has VBA codes. Could you please tell me how this file can be shared to be updated and synced with other users in Office 365?
@MyExcelOnline
Жыл бұрын
Thanks for the question. Are you asking how you know a workbook has VBA? It should have a .xlsm extension with the m being for macro. You can upload it and share it in OneDrive or SharePoint. If Sharing, SharePoint may be better. Hope that helps!
Can i send Excel file through the outlook after my work completed with the help of macro
@MyExcelOnline
4 жыл бұрын
Here is the code to "Attach your current workbook into an Outlook email message": Sub AttachWorkbookIntoEmailMessage() Dim OutlookApp As Object Dim OutlookMail As Object Set OutlookApp = CreateObject("Outlook.Application") Set OutlookMail = OutlookApp.CreateItem(0) 'Let us create the email message and display it 'Make sure to change the parameters below With OutlookMail .To = "support@myexcelonline.com" .Subject = "Have a look at this workbook" .Body = "Hey John, Could you help out on this?" .Attachments.Add ActiveWorkbook.FullName .Display End With Set OutlookMail = Nothing Set OutlookApp = Nothing End Sub
Hey, please help in VBA Codes for the work, i have workbook with 2 sheet, data available in sheet1 and same header available in sheet2, and the code should work for it will match the header and pull the data from sheet 1and paste it in sheet2 as per the header matched. if you share the code it will help me more. thanks
@MyExcelOnline
Жыл бұрын
Hi. Thanks for the question. That's a little more complicated that we could help with in a comment, but we have a consulting service that could help you. Please check out www.myexcelonline.com/microsoft-excel-consulting-services/
If anyone know other Kyle's tutorials pls make a list
@MyExcelOnline
5 ай бұрын
Hi. Yes, we have a complete set of Kyle's tutorials here: join.myexcelonline.com/
I have 2 questions. 1. How to define live month in in excel macro? 2. How to create dynamic filter?
@MyExcelOnline
2 жыл бұрын
you can use the MONTH function to get the current month. Check our blog for more info: www.myexcelonline.com/blog/
Mom: So what'd you do today? Me: Learned Macros from the blue man Mom: What did we say about lying? Me: Mom(1).Delete
@justjustin2898
3 жыл бұрын
I don’t get it. Be back in 1:22:26
@MyExcelOnline
3 жыл бұрын
😃
Good Day sir, Hope you can help. We had an employee leave the company and he changed the passwords fo rthe VBA editor on all of our templates. He had taken most of our templates and removed the menu bars and ribbons. We cant even use the undo feature. is there a way to find the password or remove it at least?
@MyExcelOnline
2 жыл бұрын
Hi Colin. Yes there is a way. This video is actually on our list of one to make soon. It's a little involved, but you can do it. First, make a backup of your Excel workbook and save it to another folder just in case you make a mistake. Then work with either the iriginal file or the back up and do the following: 1. Change the extension of the protected worksheet: rename it from *.xlsx to *.zip. 2. Open the ZIP File, double-click the "xl" folder, and then open the "worksheets" folder. 3. In there, you can find the spreadsheets (in .xml format). 4. Open a sheet file in Notepad. Now search for the content:
Dr Manhattan is teaching us Macros/VBA
@MyExcelOnline
3 жыл бұрын
😃
Hi, what is the technic! when sheet 1 entry sheet was complete and recorded, applying to database worksheet sheet 2 to record all rows isn't work please assist.
@MyExcelOnline
7 ай бұрын
Hi. Thanks for the question. Could you please let us know the timestamp in the video where you are having issues? Thank you.
That Delete Confirmation Popup can get annoying after a while. Is there a macro to disable that?
@MyExcelOnline
5 жыл бұрын
Hey Nam, can you please explain when this is happening to you?
@spyxxx566
5 жыл бұрын
@@MyExcelOnline when. The macro delete the worksheet
@MyExcelOnline
5 жыл бұрын
@@spyxxx566 Application.DisplayAlerts = False
How do I assign a button to Clear the contents of specific cells on an excel template?
@MyExcelOnline
3 жыл бұрын
On the File tab, go to Options > Customize Ribbon. Under Customize the Ribbon and under Main Tabs, select the Developer check box. A new Ribbon will appear and from here you can create a button and assign a macro to that button.
Hello everyone! New to VBA and was hoping you could help me put. I am trying to hide rows (all the sam rows) in multiple sheets. Is there a quick vba that you can think off? Current I have DIM R1 as string, R2 as string..R1 = range("AC2"), R2 = range ("AD2")...rows(R1 & ":" &R2) .entirerow.hidden = true...there are about 30 rows i need to hide and about 11 sheets, so you can imagine with the script I currently have, how long it is...im sure there is a more advanced and shorter way to write this..please help!
@MyExcelOnline
3 жыл бұрын
Hi. I am thinking this may work (the code hides Row 2, but you can put in the correct row that you would like to hide): Dim wsh As Worksheet For Each wsh In Worksheets wsh.Select Rows("2:2").Select Selection.EntireRow.Hidden = True Next wsh
thank you for the video. I have a question for Printer object and Printers object. is any Reference library required to install in the Tool->Reference before we can use Pinter and Printers object? I run below code, and get error "object is required" for line "For Each prt In Printers". Sub ListPrinters() Dim prt As Printer For Each prt In Printers Debug.Print Printer.deviceName Next prt End Sub
@MyExcelOnline
6 ай бұрын
Go to Tools -> References and make sure that Microsoft Access Object Library is checked.
Sir Assume, we have columns emp code, name, date and attendance from 1 to 31. How to clear cells as per the date updated in column number 3. If i put date as 4th march 2021, I need the cells as blank from columns 5th March to 31st March. If it is possible, pls help..
@MyExcelOnline
3 жыл бұрын
Please check out our Blog here for the answer: www.myexcelonline.com/blog/
I want to create new macro to replace given path to other tab as input given through macro
@MyExcelOnline
2 жыл бұрын
Please check out our blog for more info: www.myexcelonline.com/blog/
How can "i" stand for two things at once? i=1 and i=i+1. Is the first i a variable and the second a loop variable or something specific to the loop? I don't get it.
@prashantsharma859
4 жыл бұрын
i=1 (First Instance) declares the value of i as 1. Then conditions are checked ie, 1
@MyExcelOnline
4 жыл бұрын
They’re the same variable. One of the benefits of working with variables is they can change their value as the procedure runs. In this case we initialize “i” to be equal to 1. But each time it loops we increase the current value of “i” by 1. You do have the option to create static variables that can’t change their value. But in this case we want the variable to be able to change.
how to apply macro recorded to another excel which have more rows compared to the recorded macro?
@MyExcelOnline
2 жыл бұрын
You'd have to adjust the row count in the VBA code. Can you provide some code here? Or visit our blog at www.myexcelonline.com/blog/