| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sum column values and insert result in last cell with VBA
Try
With ActiveSheet.Cells(Rows.Count, "AL").End(xlUp)(2, 1) .Formula = "=SUM(AL1:" & .Offset(-1, 0).Address & ")" End With -- Cordially, Chip Pearson Microsoft Most Valuable Professional Excel Product Group Pearson Software Consulting, LLC www.cpearson.com (email on web site) "Les" wrote in message ... Hi all, This is probably so simple but it is eluding me... Column "AL" has a variable number of values in it and i need to get the total and paste only the total in the cell below the last used cell. Could somebody please help me out of my misery... :-0) Thnks in advance -- Les |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How calculate a difference btwn 2 TextBox and insert the result inthe appropriate cell | Excel Discussion (Misc queries) | |||
| insert column header in cell below result of max FUNCTION | Excel Worksheet Functions | |||
| How to insert line of text on other worksheet depending upon result in a cell? | Excel Discussion (Misc queries) | |||
| How to insert line on other worksheet depending upon result in cell? | Excel Discussion (Misc queries) | |||
| Macro to insert formula result into range with zero values in cell | Excel Programming | |||
Threaded Mode
