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

Macro

ResolvedVersion 2007

Wed 21 Jan 2009, 16:26 Delegate Vipesh said...

Vipesh has attended:
Excel Advanced course
Excel VBA Intro Intermediate course

Macro

how do you edit macros

Tue 3 Feb 2009, 09:33 Trainer Andrew said...

RE: Macro

Hi Vipesh

Thank you for your question. To edit macros go to the Tools menu and choose Macro > Macros and from the dialog box that comes up select the macro you would like to edit and click the Edit button.

I hope this helps - do let us know if you have any further questions.

Kind regards,
Andrew

Mon 9 Feb 2009: Automatically marked as resolved.

Training courses

98.6 % 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

Macro

Macro

RE: Macro

Excel articles

Excel tip:

Sum Up All the Values in A Column