Sum with New Cell Reference
 

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

Sum with New Cell Reference
 

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


"DOUG" wrote:

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

Sum with New Cell Reference
 

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

If this post helps click Yes
---------------
Jacob Skaria


"Jacob Skaria" wrote:

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


"DOUG" wrote:

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