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

macro

ResolvedVersion 2003

Nadia has attended:
Excel Advanced course

Macro

How to add and take out data from a Macro

Edited on Mon 21 Jul 2008, 10:57

RE: Macro

Hi Nadia,

Thank you for your post, and welcome to the forum.

In answer to your question; Before undertaking any editing on essential objects you should ensure you are working on a copy of the original, this way should unforeseen errors occur you will not have corrupted your database.

Sometimes it is better to re-record the Macro if it is a simple set of instructions/operations. However if this is not possible:

1. Go to File>New and open a new Worksheet. Then go to Window>Unhide to bring the personal macro workbook forward

Excel tip:

Moving between split pane sections in a spreadsheet

If you have used the split panes feature in your worksheet, use the following keyboard shortcut keys to move quickly and effortlessly between paned sections:

F6 - Move to the next pane
Shift + F6 - Move to the previous pane

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.