Logo 
Search:

MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Addition at the same column

  Asked By: Lorraine    Date: Nov 29    Category: MS Office    Views: 877
  

I want make an addition on the same column and
alternating rows. The column should also make an
addition during the end of the column. I try with this
but I am not succesfull?

Sub Macro1()
'
' Keyboard Shortcut: Ctrl+w
X = 3
For y = 1 To 7
For inc = 1 To 9
Cells(y, X).Select
Cells(y + 1, X) = Cells(y + 2, X) + Cells(y +
3, X)
'Selection.Delete Shift:=xlUp
Next inc
Next y
End Sub

Share: 

 

1 Answer Found

 
Answer #1    Answered By: William Bouchard     Answered On: Nov 29

I don't completely understand, but if you want alternating rows,
maybe you could step by 2:

Sub test2()
For Row = 1 To 9 Step 2
`commands
Next
End Sub

 
Didn't find what you were looking for? Find more on Addition at the same column Or get search suggestion and latest updates.




Tagged: