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

macros

ResolvedVersion 2003

Patricia has attended:
Excel Advanced course

Macros

If I have created a macro and notice an error afterwards. How can I identify the error on the set into it function?

RE: Macros

Hello Patricia,

If you have created a macro and you wish to identify the error, all you have to do is go into Tools --> Macro --> Macros (or Alt+F8), then edit the error by using the editor.

I hope this helps. If you have further information on this query, then please contact us.

Regards

Greg Eze

Excel tip:

Quickly select a block of data

To quickly select a block of data make sure your active cell is somewhere whithin the block of data and then press Ctrl+* or Ctrl+Shift+8.

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.