Macro procedures

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to record a macro which begins with a cell that I click on, and
the references up the same column 5 rows to complete a calculation. Once
finished it should move down 5 rows and repeat process. Can't make it not
reference specific cell. Any suggestions??
 
Sub AAA()
ActiveCell.FormulaR1C1 = "=Sum(R[-1]C:R[-4]C)"
ActiveCell.Offset(5, 0).Select
End Sub

assume you click in E5. and run the macro

It will put in the formula =Sum(E1:E4), then move to E10. Click again, it
will put in the sum
=Sum(E6:E9) then move to E15
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Find Specific Rows in Range and Create New Tab 18
Code to do a simple clean of one column by copying and pasting(finding and replacing) phrases in adj 4
Insert Row also adds formulas and moves cursor 2
Macro or VBA to Clear Contents of Rows By Date (Starting At A5) 1
macro recording 3
Merge data by macro 9
Running macro operations in serial fashion 6
Need help with recorded macro 11

Back
Top