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 :)

4:24 to be exact but thanks!

Hey Jamal, Glad you liked this Excel Macros & VBA tutorial!

That's great! Thanks for the positive feedback!

You are welcome

5:46

Practice makes perfect Rachel, keep on Excelling!

Hey FW, Glad you liked this Excel Macros & VBA tutorial!

Sir can u help me I have one file that I need different format to make macro ....plz hlp me sir

Glad you enjoyed it!

5:37

You are welcome! Thanks for the compliment!

Glad it was helpful!

We are glad that you were able to learn the "do while" looping and become more confident in Excel VBA!

5:25

That's great! Thanks so much!

Thanks for the tips! Those ARE good macros.

And check out our site for more macros: www.myexcelonline.com/137-42.html

Thank you!

Oh, thank you! We try hard to make videos easy for everyone to understand.

Glad it was helpful! Thanks for watching.

Welcome to the exciting world of coding Roger :)

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!

Thanks for your comment and feel free to share this with your friends and colleagues :)

Most welcome! Thanks for watching!

So nice of you. Thanks!

Thanks for your feedback and that is a great tip!

1.5 is fine too. I was dying... Thanks for the tip.

Thank you for the tips,

I'm watching at 2x and it's fine now

Glad to hear it!

Glad you enjoyed this Excel Macros & VBA tutorial Sandeep! Feel free to share with your friends :) Cheers, John

You are welcome Chris and make sure to check out our other awesome Excel tutorials on our KZfaq channel and over at www.myexcelonline.com/blog/

You are most welcome and glad you learned how to use Macros & VBA to automate your Excel worksheets & reports!

That’s awesome to hear VC! Feel free to share our channel with your friends 👍

Thank you!

Glad you liked it

It’s possible with Macros & VBA!!!

Thank you for your nice comments Idowu!

I hope you learned a lot of new Excel & VBA tips!

Glad you liked it.

My pleasure! So glad you found this helpful!

Thank YOU for letting us know!

HAHA! Thanks for watching.

I'm glad you enjoyed this Macros & VBA tutorial Mauricio!

Hey Sitara, we have more VBA tutorials over at our Academy online course here: www.myexcelonline.com/academy/enroll-eg/

Thanks Karen and I hope that Macros & VBA are much easier to you now!

Our pleasure! Glad you liked it!

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.

Here we have 101 Macros for you: www.myexcelonline.com/blog/101-excel-macros-examples/

Hi! Thanks for the feedback. Check our blog at www.myexcelonline.com/blog

Hey Jim, unfortunate the video is not downloadable but you can watch it as many times as you like here 😀

Great! Glad you now want to learn more. Check out our website and blog at www.myexcelonline.com/blog/ to learn even more!

You are welcome Moses!

Hi Kyle! Glad to see you are still using Excel! Thanks for responding!

Glad you enjoyed this Brenda! Cheers, John

Hi

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 :)

You are welcome 🙏

Thanks!

Im glad you enjoyed this Macros & VBA tutorial Siafa :)

You are very welcome. Excel IS magical! And really fun to use!

I am glad you enjoyed our Macros & VBA tutorial Thato!

Thanks! Glad you liked it!

Thank you! Cheers!

Hi. Yes, we have a complete set of Kyle's tutorials here: join.myexcelonline.com/

Unfortunately we don’t have those specific courses at the moment

Please check out our blog for more info: www.myexcelonline.com/blog/

You are correct! Hopefully it was enough to get you interested in VBA.

Thank you!

Our pleasure!

Is this what you need Preeti?

From cst microwave studio i nees

Is it possible to convert user dialog commands in VBA to normal commands

I don’t get it. Be back in 1:22:26

😃

You're welcome!

We have a dashboard series AND a VBA series if you'd like to check them out.

kzfaq.info/get/bejne/jJySf6SFq92Yhqs.html

Also, there's an intro to dashboards in this playlist, towards the bottom: kzfaq.info/get/bejne/rKdigcyKzq3Pl6c.html

And if you don't find what you need there, please check out our blog: www.myexcelonline.com/blog/

It might be better for you to use Power Query, as PQ is perfect for data transformations.

You are welcome

you can use the MONTH function to get the current month. Check our blog for more info: www.myexcelonline.com/blog/

You're welcome!

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/

Hi. Thanks for the question. Could you please let us know the timestamp in the video where you are having issues? Thank you.

You can create a filesystemobject and use the CreateTextFile method. Also, visit our blog for lots of tips: www.myexcelonline.com/blog/

😃

Hey Janet yes it does! Just go to our website myexcelonline.com and drop us an email there. We will get you setup asap! 💚

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!

Hey Nam, can you please explain when this is happening to you?

@@MyExcelOnline when. The macro delete the worksheet

@@spyxxx566 Application.DisplayAlerts = False

Thank you!

Go to Tools -> References and make sure that Microsoft Access Object Library is checked.

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.

Good tip!

Glad you enjoyed this Excel Macros & VBA tutorial for beginners! Cheers, John

Hi. Thanks for writing! Could you please clarify what percentage you would like?

Hi. I would suggest opening Excel and right clicking on the ribbon and choosing Customize the Ribbon.... On the right side of the screen you should be able to check the Developer ribbon again. Please let us know if you have anymore questions!

Here is what Microsoft says about adding worksheets: "Limits on Sheets in a workbook are Limited by available memory (default is 1 sheet)". Are you having trouble adding more sheets to your workbook?

You are most welcome Nasta!

Please check our blog and if you don't find the answer, feel free to contact us there. www.myexcelonline.com/blog/

Please look at this tutorial which will help you out: www.myexcelonline.com/blog/conditional-format-a-cells-value/

Hi Abhishek! You could create a Macro under the View ribbon. And you can run the macro by selecting Macro|Run Macro. The macro IS VBA code. You could use it for things that aren't possible to do with a formula, like looping through cells until yo find a certain value or for processes you would do over and over again to automate them. It's a great language because it's not a hard one to learn. Check out our blog for more at www.myexcelonline.com/blog/

Hi. Thanks for watching! I would recommend downloading the sample workbook and comparing it to what you have written, as VBA needs to be exact. Or you can go back over the video and double check every line to see that it matches yours. The link to download it is in the description. Hope that helps!

Glad you enjoyed this Excel Macros & VBA tutorial for beginners! Cheers, John

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:

Thanks for the question. CTRL+F will help you to get to replace dialog box.

Yes, but I want to add it to a macro, if possible@@MyExcelOnline

Are you asking if CTRL+F can be used to run a macro? No because it is already reserved. You may be able to use CTRL+SHIFT+F.

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.

Hi. You could select everything in one sheet by clicking the square between the Column A and the Row 1. That will select the whole sheet. Then you can copy everything that is selected in Worksheet A and paste it into the new sheets. Does that answer your question?

@@MyExcelOnline Thanks for your reply, but I want to transfer some to particular items only to the another workbook

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/

If you save your Excel sheet as a .csv, you can then go into Outlook and File|Open & Export||Import/Export and go to Import From Another Program. See if that helps you get started.

You can copy whichever direction you like

Please check out our Blog here for the answer: www.myexcelonline.com/blog/

Thanks

Glad to hear that Mariann!