Macros

hgg_21

New Member
Joined
Apr 23, 2002
Messages
17
Hi,

Sorry if u think this is a stupid question. But I want to know what does macros in excel do and how do i create one?

regards
 

Excel Facts

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a $25,000 loan, 5% annual interest, 60 month loan.
Your best bet is to look at the Excel help file, under Macro Overview. This explains what a macro is used for. Under Macro Creating you will find out how to create one. When you have a specific task in mind for your macro post a request up here and someone will help you if you're having trouble

Audiojoe
 
Upvote 0
Look up Macro in the Help file, and look at the following :-

Macros: Automating tasks you perform frequently

Record a macro

Run a macro
 
Upvote 0
Hi,

I have two tabs in an excel file. I need to create a macro that can insert an additional tab and insert data in one of the tab into the new tab plus some additional fields.
Can I have a rough idea how to go about doing it?

Thanks and regards
 
Upvote 0
To begin with, just try going to Tools>Macro>Record New Macro. Now give your macro a name and click OK

Now just do whatever it is that you want the macro to do and when you're finished, go to Tools>Macro>Stop Recording.

Now you have recorded the macro and what you want it to do. Every time you want to use it you go to Tools>Macro>Macros and select it OR you can assign it to a button by drawing one and right clicking then choosing Assign Macro

Audiojoe
 
Upvote 0
hi,

thanks for the fast reply.
I m very new to this macro thing. I shall now go read up on it and do so examples.
Will be back when I encounter any problems and hope that u be here to help!

Thanks and regards!!!
 
Upvote 0

Forum statistics

Threads
1,213,520
Messages
6,114,101
Members
448,548
Latest member
harryls

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