| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how do I set the position to a specific cell location in excel
I want to make a macro in excel that will go to the end of a data column and
do a summation of the data in the row immediately following the data. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
how do I set the position to a specific cell location in excel
lastrow = Cells(Rows.Count, "A").End(xlUp).Row ' will give last row in column A
Cells(lastrow + 1, "A") = Application.Sum(Range(Cells(2, "A"), Cells(lastrow, "A"))) HTH "lpdarspe" wrote: I want to make a macro in excel that will go to the end of a data column and do a summation of the data in the row immediately following the data. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
how do I set the position to a specific cell location in excel
and just to give another option, if you want a formula instead of the value for
the total, you could use this Range("A" & Lastrow + 1).Formula = "=sum(A2:A" & Lastrow & ")" -- Gary "lpdarspe" wrote in message ... I want to make a macro in excel that will go to the end of a data column and do a summation of the data in the row immediately following the data. |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
how do I set the position to a specific cell location in excel
Thank you very much. It fit the requirements exactly!
"Gary Keramidas" wrote: and just to give another option, if you want a formula instead of the value for the total, you could use this Range("A" & Lastrow + 1).Formula = "=sum(A2:A" & Lastrow & ")" -- Gary "lpdarspe" wrote in message ... I want to make a macro in excel that will go to the end of a data column and do a summation of the data in the row immediately following the data. |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
how do I set the position to a specific cell location in excel
Thanks! It fit my requirements exactly!!
"Toppers" wrote: lastrow = Cells(Rows.Count, "A").End(xlUp).Row ' will give last row in column A Cells(lastrow + 1, "A") = Application.Sum(Range(Cells(2, "A"), Cells(lastrow, "A"))) HTH "lpdarspe" wrote: I want to make a macro in excel that will go to the end of a data column and do a summation of the data in the row immediately following the data. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003- Tabbing to a specific location in a cell | Excel Discussion (Misc queries) | |||
| How to determine the value within specific cell position? | Excel Discussion (Misc queries) | |||
| Replacing a specific position in a cell with something else | Excel Discussion (Misc queries) | |||
| hyperlink an excel cell to a specific location wthin application f | New Users to Excel | |||
| hyperlink an excel cell to a specific location wthin application f | Excel Discussion (Misc queries) | |||
Linear Mode
