One of the best redemptions available is flying first class from the U.S. to Abu Dhabi. This award would cost you 115,000 AAdvantage bonus miles one-way in the first class apartment. Business class on the same flight would cost 70,000 American Airlines miles, and economy goes for a mere 40,000 miles each way.
Copying a module from one workbook to another. If the Developer tab is not available, do the following to display it: Click Options, and then click the Customize Ribbon category. Under Main Tabs, select the Developer check box and then click OK. macro is an action or set of actions that you can use to automate tasks. You can record macros by using the Record Macro command (Developer tab, Code group). Macros are recorded in the VBA programming language. You can inspect and edit your macros in the Visual Basic Editor, a window that is opened by Excel.
In the code window of the Visual Basic Editor, select the lines of the macro that you want to copy. Tip To copy the whole macro, include the Sub and End Sub lines in the selection. On the Edit menu, click Copy. Tip You can also right-click and then click Copy, or you can press CTRL+C.In the Procedure box of the code window, click the module where you want to place the code. On the Edit menu, click Paste.n the Description box, type a description of the macro. Click OK to start recording. Perform the actions that you want to record. On the Developer tab, in the Code group, click Stop Recording. Tip You can also click Stop Recording on the left side of the status bar.