Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

macros

ResolvedVersion 2003

Tom has attended:
Excel Advanced course

Macros

Can you record Macros in steps and then stitch them together in visual basic?

RE: Macros

Hi Tom

Thanks for the post - sorry for late response

You can stitch them together through VBA by recording them in Excel first in parts storing them in your personal workbook then going into VBA, and cutting and pasting them together make sure you paste them in the riight location and test them out after you are finished

Hope this helps

If this posting has helped in answering your query then I would request you to mark the posting as Resolved. If, however, it hasn

Mon 8 Dec 2008: Automatically marked as resolved.

Excel tip:

Activating the formula bar with the keyboard in Excel 2010

The formula bar in Excel 2010 contains a number of different formulas. However, it is time consuming to open the formula bar every time and insert the formula using the mouse. Instead, you can activate the formula bar with the keyboard. Simply press the F2 button on the keyboard then the information in the cell will expand allowing you to edit the information in the cell.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.