shajueasow
Well-known Member
- Joined
- Oct 7, 2004
- Messages
- 1,926
This is the code got while recording a macro to get the total (AutoSum) of numbers in Col A. Since the list is a dynamic one how can it be coded so that it totals all rows with number in it? (All consecutive cells have numbers in them without break. In this case it has numbers till A10, and the total is to be at A11)
Sub gettotal()
Range("A1").Select
Selection.End(xlDown).Select
Range("A11").Select
ActiveCell.FormulaR1C1 = "=SUM(R[-10]C:R[-1]C)"
End Sub
TIA
Sub gettotal()
Range("A1").Select
Selection.End(xlDown).Select
Range("A11").Select
ActiveCell.FormulaR1C1 = "=SUM(R[-10]C:R[-1]C)"
End Sub
TIA