Скачать или смотреть How to add a new row in Excel using a Macro? - Easy Excel - Make Excel work for you!

In this video we look at a real life example of issues people may face when using the spreadsheet we have created.

Based on the feedback our imaginary employees have given us, we decide we need to leave the table with a blank row at the the bottom after every use.

We decide to add to the existing macro button to make this easier. To do this we need to first record a new macro. Then we need to use the Visual Basic Editor to identify, copy and paste the VBA code we need to change the macro.(Sounds complicated... watch the video to see how it's done)

If you have been following along on this channel you will know that we like to set things up once and then forget about it. Make excel do the work every time and we only have to do the work once to set it up. That's the aim, that's what we are trying to achieve here on this channel.

Thanks for watching with Easy Excel!

A bit about this channel......

My name is Chris and I'm the voice behind Easy Excel.
I believe that spreadsheets should be a tool to help us in our work, not be something scary or a hindrance. That's why with this channel, I want to take you through everything from the basics to the more advanced features of Microsoft Excel.

The difference with this channel?

We are taking a "Learn with us" approach. Using the same document from the very beginning we will add, edit and change the features depending on the task we need to do.

You'll find short videos showing you quick tips and longer videos explaining in depth scenarios.

Learn formulas, user friendly tips, Mac ro's, VBA and more!

If you are new here check out some of our other videos below:

First video - Setting ourselves up for success:
   • What is a table in Microsoft Excel and how...  

Learn counting formulas:
   • How do I use the count functions in Excel?...  

#Excelmacro #editmacro #addnewrowexcel #exceltips #EasyExcel

This description contains affiliate links, including links to Amazon.
As an Amazon Associate I may earn commission on any qualifying purchases.

Video Thumbnail created on Canva - https://bit.ly/37zEz2p

More info about Microsoft Office 365: https://amzn.to/3pDfuK4

The computer I use:
https://tidd.ly/3bDYte3

Microphone I use:
https://tidd.ly/3qHT3EQ
https://amzn.to/3pFB28Z

Anti virus software:
https://tidd.ly/3pD1YGr

Get Microsoft Office 365 Family: https://amzn.to/2McKvae
Get Microsoft Office 365 Personal: https://amzn.to/2ZAJQCA
Get Microsoft Office 365 Business: https://amzn.to/37yBi3h