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

macros

ResolvedVersion 2003

Rowen has attended:
Excel Advanced course

Macros

are there practical examples of macros avaiable for download somewhere?

RE: Macros

Hi Rowen

Thank you for your question regarding Macros

There are plenty of places to find examples of Macros for Excel on the web. The main problem though is that Macros can cover a huge range of topics and so its hard to point you to a useful library.

I would recommend having a look at recording a few, look at the code and then come on a VBA course with us which will open up a whole new side of Excel for you.


Please let me know how you get on.


Laura GB

Excel tip:

Selecting constant values only

If periodically you need to change all your values back to zero, but leave formulas, text and blank cells as they are select the entire worksheet, choose F5 function key, Special and then Constants and choose the appropriate sub-selections. To enter zero in all the selected cells type 0 and then press Ctrl+Enter.

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.