| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Nesting a sheet name reference within a cell reference??? | Excel Discussion (Misc queries) | |||
| Formulas that reference cells that reference another cell | Excel Discussion (Misc queries) | |||
| absolute cell reference A spreadsheet cell reference that does no | Excel Discussion (Misc queries) | |||
| problem with cell reference in =sum(offset(cell reference,x,y,z,a)). Want cell ref to be variable. | Excel Worksheet Functions | |||
| Problem with =sum(offset(cell reference,w,x,y,z). I want cell reference to be variable | Excel Worksheet Functions | |||
Linear Mode
