| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Summing a Column of Variable Length
Sub Sum1()
Dim iEnd As Integer iEnd = Sheets("Master").Range("D1").End(xlDown).Row Sheets("Monthly").Range("Z1").Formula = "=SUM(Master!D1:D" & iEnd & ")" End Sub Hth, Merjet |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Summing a column based on the length of text in a cell in anothercolumn | Excel Worksheet Functions | |||
| Autosum a variable column length using VB | Excel Programming | |||
| Sum a Column of Variable length | Excel Discussion (Misc queries) | |||
| Sum a column of variable length? | Excel Discussion (Misc queries) | |||
| Averaging a variable length column | Excel Programming | |||
Hybrid Mode
