| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Adding "TOTAL" and summing column
Fred
Try thnis Code gets row number of last used cell in Column H Dim LastRow As Long LastRow = Cells(Rows.Count, "h") _ .End(xlUp).Row Cells(LastRow + 2, "h").Value = "TOTAL" Cells(LastRow + 2, "j").Value = _ "=sum(j4:j" & LastRow & ") -- Message posted from http://www.ExcelForum.com |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding data only if adjacent to cell labeled "male"/"female" | Excel Worksheet Functions | |||
| Column "SUM" Not SUMming | Excel Discussion (Misc queries) | |||
| Need column evaluated to count total of occurrences of "Y". How? | Excel Worksheet Functions | |||
| Linking two "total" pages to create a "Complete Total" page | Excel Worksheet Functions | |||
| Adding "New" "Insert" "Delete" into a workbook to change from data 1 to data 2 etc | Excel Programming | |||
![mudraker[_220_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
