macros

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

TrustPilot

starstarstarstarstar Excellent

  • Home
  • Courses
  • Promotions
  • Schedule
  • Formats
  • Our Clients

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Macros

Macros

resolvedResolved · Low Priority · Version 2007

Konstantina has attended:
Excel Advanced course

Macros

how do you undo a macro command?

RE: macros

Once you have run a macro command, the undo facility is no longer enabled. The reason for this is because you have carried out a set of commands, ie a Macro, as opposed to a single command or action.

Therefore once you have carried out a macro command you are unable to undo the actions automatically. If you can remember the various steps of the macro you will be able to manually undo by undertaking each step separately.

Fri 16 Jan 2009: Automatically marked as resolved.


 

Excel tip:

Generate randon numbers

Some types of analysis require you to use randomly generated numbers. You can also use randomly generated numbers to quickly populate an Excel spreadsheet. There's an easy function you can use to do this automatically. Here are a few of the ways you can use it:

Type =RAND() in a cell to generate a number between 0 and 1.
Type =RAND()*100 to generate a number between 1 and 100.

View all Excel hints and tips


Server loaded in 0.08 secs.