Summation Macro

smittycft99 · Apr 22nd, 2002, 09:34 AM

I just want to run a macro to sum a column then place the output in a cell. Output cell is not at the bottom of the column.

Al Chara · Apr 22nd, 2002, 11:09 AM

Do you really need a macro for this...?
=Sum(A:A) will do nicely.

smittycft99 · Apr 22nd, 2002, 11:15 AM

Al

I wanted a macro to sum the column where the length of the column varies and assign to a shortcut key. The summation would be placed at the end of the column.

Sam40mUK · Apr 22nd, 2002, 12:11 PM

Evening,
There has been some discussion concerning AutoSum via VBA code .. perhaps it maybe worth a look?

http://www.mrexcel.com/board/viewtop...2691&forum=2&3

Regards
S

Apr 22nd, 2002, 11:09 AM	#2
Al Chara MrExcel MVP Join Date: Feb 2002 Location: Monterrey, Mexico Posts: 1,433	Do you really need a macro for this...? =Sum(A:A) will do nicely. __________________ Kind regards, Al Chara

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 22nd, 2002, 09:34 AM	#1
smittycft99 Board Regular Join Date: Apr 2002 Posts: 130	I just want to run a macro to sum a column then place the output in a cell. Output cell is not at the bottom of the column.

Apr 22nd, 2002, 11:15 AM	#3
smittycft99 Board Regular Join Date: Apr 2002 Posts: 130	Al I wanted a macro to sum the column where the length of the column varies and assign to a shortcut key. The summation would be placed at the end of the column.

Apr 22nd, 2002, 12:11 PM	#4
Sam40mUK Board Regular Join Date: Mar 2002 Location: North Wales Coast, UK Posts: 95	Evening, There has been some discussion concerning AutoSum via VBA code .. perhaps it maybe worth a look? http://www.mrexcel.com/board/viewtop...2691&forum=2&3 Regards S