Macros

Resolved · Low Priority · Version 2007

Wed 23 Sep 2009, 16:52 Delegate Mary said...

Mary has attended:
Excel Intermediate course
Excel Advanced course

Macros

how to use macros on multiple sheets?

Thu 24 Sep 2009, 11:04 Trainer Stephen said...

RE: Macros

Hi mary

Thank you for your question

Could you narrow your question down a bit for me? What particulaly do you wnat to do with your macro, for example do you wish to copy data from one worksheet to another?

Thanks

Stephen

Thu 19 Nov 2009, 09:33 Trainer Rich said...

RE: Macros

Hi Mary,

This question has now been left unattended for a while.

We like to keep down the large number of active forum posts we receive.

As we are waiting for your response for further information to help resolve your issue, we will be automatically marking this question as resolved in the next 5 days (unless you post a follow-up within that time).

We look forward to hearing from you.

Thank you.
Regards, Rich

Wed 25 Nov 2009: Automatically marked as resolved.

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Excel tip:

Quickly insert a function

In Excel 97 and 2000 it was known as the Paste Function dialog box, these days it's known as the Insert Function dialog box. Regardless, one has to choose Insert|Function. or the fx button to open it up. There is, however, a non-mousey way to get hold of the Insert Function dialog box: press Shift+F3 in a blank cell to open the Insert Function dialog.

Press Shift+F3 after a function name and open bracket to open the Function Arguments dialog. For example, type =VLOOKUP( into a cell and press Shift+F3 to obtain a detailed description of VLOOKUP's arguments.

View all Excel hints and tips