Sum with New Cell Reference

  • Thread starter Thread starter DOUG
  • Start date Start date
D

DOUG

I am designing a macro to link to a cell reference and to move the reference
two cells to the right in the following month. So, this month I the formula
refers to cell II14. Next month, after I run the macro, I want it to refer
to cell J14. Please advise.

DOUG
 
I14 can be represented as either Range("I14) OR Cells(14,9).

Here you can use Cells(14+1,9) where +1 is for the next month. Replace this
with variables and increment with months....


If this post helps click Yes
 
Back
Top