How to Recording a Macro in Excel

The Easiest and the fastest way to learn Excel VBA Programming is by using the Recording Macro feature. This cool feature of Excel will record all the steps you perform on Excel sheet and generate a Code. You can later view the code and see how your actions are translated into VBA Code.

Procedure to Record a Macro

1. Click Tools > Macro > Record New Macro

2. Enter the desired Macro Name and click Ok to start Macro Recording .

If you want you can also give a shortcut Key to Recorded Macro. Select Store macro in “This Workbook” so that the Recorded Macro is saved right inside the Excel sheet. If you choose this option and send the sheet to someone then the Recorded Macro will also be sent.

Note: If you store macro in “Personal Macro Workbook” then the Recorded Macro will not be saved inside the Excel sheet. Recorded Macro will be stored in Personal Sheet. Personal.xls file is created when a Macro is recorded to it for the first time and it is saved in \XLStart directory of MS Office. It is advisable to store the frequently used Macros in “Personal Macro Workbook” so that they are always available from any sheet but if you send the Excel sheet to someone, the Macro will not be sent along with the Excel Sheet.

A Shortcut Key can also be assigned to the Recorded Macro. Press "s" to assign CTRL + s OR Press "S" to assign CTRL + SHIFT + S

In our next posts we will discuss some of the examples where we will record a macro to automate some day-to-day tasks.

watches

tier watches replica sale per number to best price Rolex GMT Master watches units per moment. watch UK The dial of watch prices this use is Finest Rolex extraordinarily exhilarant besides Rolex Watches although actual has Omega watches multifold functions to watches price display, the works Replica Rolex these functions are replica watch placed aptly to rolex watches insure a thoroughly watches replica legible dial. The replica watches supreme inducement of replica watches surprise is the fake IWC watches advent that the watches replicas dial one's way automatic watches vertically alike sub-dials fake Omega watches because the functions Omega Fake Watches of the chronograph. best Corum watches At three o’clock wristwatch on sale we albatross subscribe cheap Rolex watches to displayed a O

Here is watch replica a step

Money gayweather loves

Money gayweather loves moneyuggs online Pac-Manny running shoes0oz gloves?
ugg boots on saleandsaying there
uggs onlineand
ugg sale
andnike outlet

Post new comment

The content of this field is kept private and will not be shown publicly.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Allowed HTML tags: <a> <em> <strong> <cite> <code> <ul> <ol> <li> <dl> <dt> <dd>
  • Lines and paragraphs break automatically.

More information about formatting options

CAPTCHA
This question is for testing whether you are a human visitor and to prevent automated spam submissions.
11 + 4 =
Solve this simple math problem and enter the result. E.g. for 1+3, enter 4.