If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|