Macro code for sum of 3 rows

Closed
adithya_shastri Posts 1 Registration date Monday March 11, 2013 Status Member Last seen March 11, 2013 - Mar 11, 2013 at 08:36 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Mar 11, 2013 at 12:41 PM
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 September 12, 2010 Status Moderator Last seen December 27, 2022 552
Mar 11, 2013 at 12:41 PM
Hi adithya_shastri,

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

Best regards,
Trowa