Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Go to cell below last entry in column and total
I am doing a macro and I would like for it to automatically go to the cell
below last entry in a column and total. (row count will be different each time I run the macro) One of the columns has entries in every cell,, and my other column may have blanks cells in the column. Thanks for your help. Donna |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Go to cell below last entry in column and total
Try the below which will insert a total to Col B after last row with data in
the active sheet Sub Macro() Dim lngRow As Long lngRow = ActiveSheet.Cells(Rows.Count, "B").End(xlUp).Row + 1 Range("B" & lngRow) = "=SUM(B1:B" & lngRow - 1 & ")" End Sub If this post helps click Yes --------------- Jacob Skaria "Donna" wrote: I am doing a macro and I would like for it to automatically go to the cell below last entry in a column and total. (row count will be different each time I run the macro) One of the columns has entries in every cell,, and my other column may have blanks cells in the column. Thanks for your help. Donna |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding entry in one cell to a running total in another cell | Excel Worksheet Functions | |||
copy value of cell from last entry in column | Excel Worksheet Functions | |||
Return entry in column above/below cell | Excel Worksheet Functions | |||
Move the last entry in a column to a different cell, when the loc. | Excel Worksheet Functions | |||
how do i set up a single cell continual entry in excel to total f. | Excel Discussion (Misc queries) |