Macros

Resolved · Low Priority · Version 2003

Wed 21 Oct 2009, 16:23 Delegate Enrico said...

Enrico has attended:
Excel Advanced course

Macros

Is there a list of macros ready to use? Is it possible to download and use/modify macros from somewhere?

Fri 23 Oct 2009, 09:59 Trainer Stephen said...

RE: Macros

Hi Enrico

Thanks for your question

There are a huge number of web sites where macros can be obtained. It is usually a case of copying the code into the VBE.

If you Google your requirements, this is normally sufficient to track down what you need.

However, I would be extremely cautious. You need to be sure that the code is coming from a reputable source, it is common to see code passed off as a macro, which is in fact malicious and potentially harmful. As a general rule, you should never run a macro written by a stranger if you do not understand the code.

Regards

Stephen

Excel tip:

Formula for last day of month

In some cases it is necessary to find the last day of a month for a given date. If you use the following formula, you can achieve this, ie; if you have a column of dates, use this formula to find the end of month for each day by using the fill handle. The formula is as follows, and assumes in this example that the first date in question is in cell C5, in any other cell type; =DATE(YEAR(C5),MONTH(C5)+1,1)-1

View all Excel hints and tips

Macros

Macros

RE: Macros

Excel articles

Excel tip:

Formula for last day of month