automate tasks vs repetitive instructions

lezawang

Well-known Member
Joined
Mar 27, 2016
Messages
1,805
Office Version
  1. 2016
Platform
  1. Windows
Hi in the article below it is mention that VBA is used to automate tasks and repetitive instructions.
I do not see any different between these 2. Can you give me an example of these 2 things. Thank you so much.


[h=3]Why learning Excel VBA is so important?[/h][FONT=&quot]As you become familiar with Excel, you will notice that although Excel provides you large number of tools, but still it doesn’t have everything that you need to perform your daily tasks. Such tasks may include creating custom functions, repetitive instructions, automating tasks etc.
https://www.exceltrick.com/excel-vba-basics/what-is-excel-vba/[/FONT]
 

Excel Facts

Why are there 1,048,576 rows in Excel?
The Excel team increased the size of the grid in 2007. There are 2^20 rows and 2^14 columns for a total of 17 billion cells.
Automate tasks could be a one off macro to process thousands of lines of data into a manageable form

repetitve instructions could be something that you process on a daily, weekly, monthly timeframe.....like a roster or payslip.....might only be a couple of lines of code !!

I note you have asked a number of questions relating to this theme....are you studying for something ???
 
Last edited:
Upvote 0
Thanks for your reply. I appreciate it. Yes, I am learning vba by my own. Not taking course etc. I am not student. Thanks once again
 
Upvote 0

Forum statistics

Threads
1,214,920
Messages
6,122,267
Members
449,075
Latest member
staticfluids

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top