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

macros

ResolvedVersion 2010

Sally has attended:
Excel Advanced course

Macros

Recording and running macros the system crashed at the training centre and as well as home. Why?
Many thanks

RE: Macros

Hello Sally,

Thank you for your question regarding crashing macros.

Without more information its impossible to work out why the crash happened.

What were you recording at home, at what point did it crash, and if you try it again does it crash at the same point each time? Is it during recording or playback?

If you can describe some of these, then I'll try and work out the reason for the crash.

If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?

Have a great day.
Regards,

Mark
Microsoft Office Specialist Trainer

RE: Macros

Hi Mark,
Thank you for reply regarding Macros. When I have finished recording macro and play back or run the macros the sytem crashes. It works twice and then the system crashes.
Can you suggest a simple macro that will work for me in Excel 2010?.
Many thanks
Sally

RE: Macros

Hello Sally,

Can you tell me step by step how you went about recording the macro, what you called it, how you started recording, how you stopped etc..
Then can you tell me exactly what you recorded.. did you record deleting cells, entering text, formatting etc...

It would also help if you could copy and paste the code the macro recorded, so I can read through the code.

Have a great day.
Regards,

Mark
Microsoft Office Specialist Trainer

Wed 24 Aug 2011: Automatically marked as resolved.

Excel tip:

Move data worksheet to worksheet

To move data from one worksheet to another, highlight the data.

Select and hold down the ALT key and position the mouse on the border of the selection until the mouse pointer displays four-headed arrows.

Drag the selection down to the destination worksheet tab.

When the arrow touches the tab, Excel switches to the desired worksheet. Now drag the selection to the correct position. Let go of the mouse and then the ALT key.

To copy data from one worksheet to another, select and hold down the CTRL+ALT keystroke combination and perform the steps above.

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.11 secs.