Sum with New Cell Reference

[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

 

[Jacob Skaria]

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

 

[Jacob Skaria]

Oops Cells(14,9+1) to increment columns

If this post helps click Yes