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

Macros

ResolvedVersion 2007

Mon 8 Nov 2010, 16:25 Delegate Celia said...

Celia has attended:
Excel Intermediate course
Excel Advanced course

Macros

what is the difference between a macro and a formula

Mon 8 Nov 2010, 20:55 Trainer Rodney said...

RE: macros

Hello Celia,

Hope you enjoyed your Microsoft Excel 2007 course with Best STL.

Thank you for your question regarding the difference between a formula and a macro. A macro is a set of instructions created by a user using a mouse and keyboard which when run will carry out the instructions. A macro can contain a formula but not the other way around.

I hope this resolves your question. If it has, please mark this question as resolved.

If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?

Have a great day.
Regards,

Rodney
Microsoft Office Specialist Trainer

Mon 15 Nov 2010: Automatically marked as resolved.

Training courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Sum Up All the Values in A Column

If you want to quickly calculate the Summed values of all cells in a column in Excel 2003 normally you would use the SUM formula. (eg if you wanted to calculate the values in Column C rows 10 to 25) the formula would be:

=SUM(C10:C25)

However, if you keep adding values to column C you would keep having to modify the above SUM formula which can get quite annoying.

To get around this you can sum all the values in a column using the following formula:

=SUM(COLUMN:COLUMN)

Which, in our example, would be:

=SUM(C:C)

NOTE You cannot place this formula in column C, or else Excel 2003 will show a circular reference error.

The formula must be placed in any other column, EXCEPT the one being calculated.

View all Excel hints and tips

Macros

Macros

RE: macros

Excel articles

Excel tip:

Sum Up All the Values in A Column