Macro code for sum of 3 rows

Closed
adithya_shastri Posts 1 Registration date Monday 11 March 2013 Status Member Last seen 11 March 2013 - 11 Mar 2013 à 08:36
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 11 Mar 2013 à 12:41
Hello,
I have a problem.
I have a data in which there is only 1 column but 1000 rows.

I need a macro to get sum of 3 rows.

can anyone help me in this problem please




Related:

1 response

TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 555
11 Mar 2013 à 12:41
Hi adithya_shastri,

Why not use formula's?
Put one in A3 and in A6, select A1:A6 and drag down.

Best regards,
Trowa