Register now or log in to join your professional community.
i have seen an option in developer tab of MS Excel i just want to know how it works
If you have to repeat same set of tasks on daily basis in excel for example fathering data or etc then its a tool which actually ease your work by understanding and recording the pattern of your activities.
First you have to feed the flow of your work then MS Execl will do it by itself
You can even add your own macros to the Excel function menu, so that they are available to you in the same way as Excel's built-in functions. A macro is a piece of computer code, that is written for Excel, using the Visual Basic for Applications (VBA) programming language.
it a programming instructions stored, a code that can be used to eliminate the need tasks over and over again or its a looping tasks.
Excel macros save you time and headaches by automating common, repetitive tasks.
It is used to save our time, while working on same repetitive simple tasks. These are written in VBA.
adding number formatting to new data and worksheet formats such as borders and shading
recording and easing the nature of repeated type daily work
Marcos are recorded in the Visual Basic for Applications programming language.
A micros function can be defined as the recording of a series of tasks.
It's the simplest form of automation – show a software program the steps you follow to get something done, and the software will follow along.
When used right, micros can save you hours by automating simple, repetitive tasks.
Macro are action or set of actions recorded and used to make the repating task easier and faster.
It is a code written for excel for VBA language.
