Home » Ask & Discuss » Other Courses » Computer Applications « Back to Discussion

Computer Applications

New kid on the Block

Joined:	5 Nov 2008
Post:	5

5 Nov 2008 20:07:02 IST

0 People liked this

1187

what is macro in MS-EXCEl? explain Advantages and disadvantages of macro.

None

what is macro in MS-EXCEl? explain Advantages and disadvantages of macro.

Share this article on:

Comments (1)

Rupali Bansal

Forum Expert

Joined: 5 Nov 2008

Posts: 13

6 Nov 2008 15:30:41 IST

Like 0 people liked this

At times in MS-EXCEL we have to carry out boring repetitive tasks such as formatting of cells, changing margins etc in order to make the whole thing look more professional. these tasks are very easy to do but neded a lot of time to complte.

all we need to do is creating a macro on the beginning, and then just pressing a key. The system will do the whole boring stuff for us.

Macros are symbols, names, or keys that represent a list of commands, actions, or keystrokes.In the menu bar, go to Tools – Macro – Record New Macro. Then we give it a name and choose a location where our macro will be stored in our system. we can also assign a shortcut key combination to access the macro later on.

Advantage

it saves memory and time.because with the use of macros the compilation will become faster

for creating a macro, we don’t need any programming knowledge

Disadvantages

Lack of ability to record results - there is nothing within a macro script style macro that can be used to write results to a file for later analysis.

For long or complex tasks we need a huge macro file which can be a nightmare

Quick Reply

Reply

	Some HTML allowed.
	Keep your comments above the belt or risk having them deleted.
	Signup for a avatar to have your pictures show up by your comment
	If Members see a thread that violates the Posting Rules, bring it to the attention of the Moderator Team