| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find last row in column D then Sum
Hello from Steved
Is it possible in VBA to goto last row in Column D then to a Sum Function. I know you can find the last row but was hoping to do a sum of that column D Thankyou. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Find last row in column D then Sum
Steved:
try it, r = Range("D65536").End(xlUp) MsgBox "SUM:" & _ Application.WorksheetFunction.Sum(Range("D1:D" & r)) -- 天行健，君*以自強不息 地勢坤，君*以厚德載物 http://www.vba.com.tw/plog/ "Steved" wrote: Hello from Steved Is it possible in VBA to goto last row in Column D then to a Sum Function. I know you can find the last row but was hoping to do a sum of that column D Thankyou. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Find last row in column D then Sum
Thankyou very much.
"chijanzen" wrote: Steved: try it, r = Range("D65536").End(xlUp) MsgBox "SUM:" & _ Application.WorksheetFunction.Sum(Range("D1:D" & r)) -- 天行健，君*以自強不息 地勢坤，君*以厚德載物 http://www.vba.com.tw/plog/ "Steved" wrote: Hello from Steved Is it possible in VBA to goto last row in Column D then to a Sum Function. I know you can find the last row but was hoping to do a sum of that column D Thankyou. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| FInd common data in one column then add number in adjacent column | Excel Worksheet Functions | |||
| find last row value in column when using MATCH to find column | Excel Worksheet Functions | |||
| Find something in column a then find if column B matches criteria | Excel Discussion (Misc queries) | |||
| Find First Non blank cell than find column header and return that value | Excel Worksheet Functions | |||
| Find Column heading and then Delete entire column | Excel Programming | |||
Hybrid Mode
