replacing "R[25]C" ..pls suggest

M

monika

i want to replace "R[25]C" by the cells(row,column).address
(0,0) in the below formula. How can I do it..?

I am unable to interpret what "R[25]C" exactly means.

ActiveCell.FormulaR1C1 = _
"='Sum Jun''04'!R[25]C+'Sum Jul''04'!R[25]C+'Sum
Aug''04'!R[25]C+'Sum Sep''04'!R[25]C"

any help would be appreciated
thanks
monika
 
T

Tom Ogilvy

It means relative to the cell which contains the formula, look down 25 rows.

So if I am in R1C1 (A1) R[1]C would be A2 - one row down, same column.

R[25]C would be A26

cells(ActiveCell.Row + 25,ActiveCell.Column).Address


sAddr = ActiveCell.Offset(25,0).Address(0,0)
ActiveCell.Formula = "='Sum Jun''04'!" & sAddr & "+" & _
"'Sum Jul''04'!" & sAddr & "+" & _
"'Sum Aug''04'!" & sAddr
 
G

Guest

hi tom,

thanks for the feebback..
i tried what u wrote but its not solving my purpose.
here is what i am getting in the cell:
='Sum Jun''04'!'Q29'+'Sum Jul''04'!'Q29'+'Sum
Aug''04'!'Q29'+'Sum Sep''04'!'Q29'

instead of Q29 i want C30...I used :
sAddr = ActiveCell.Offset(25, 0).Address(0, 0)
more i need to copy paste this value...and while doing so
the address of hte cell is not changing, which normally
does????
In all the cells the address is Q29!!!!!!

i want the address to chage since i am doing copy paste..
i hope i am clear...

thanks again
monika

-----Original Message-----
It means relative to the cell which contains the formula, look down 25 rows.

So if I am in R1C1 (A1) R[1]C would be A2 - one row down, same column.

R[25]C would be A26

cells(ActiveCell.Row + 25,ActiveCell.Column).Address


sAddr = ActiveCell.Offset(25,0).Address(0,0)
ActiveCell.Formula = "='Sum Jun''04'!" & sAddr & "+" & _
"'Sum Jul''04'!" & sAddr & "+" & _
"'Sum Aug''04'!" & sAddr

--
Regards,
Tom Ogilvy



i want to replace "R[25]C" by the cells (row,column).address
(0,0) in the below formula. How can I do it..?

I am unable to interpret what "R[25]C" exactly means.

ActiveCell.FormulaR1C1 = _
"='Sum Jun''04'!R[25]C+'Sum Jul''04'!R[25]C+'Sum
Aug''04'!R[25]C+'Sum Sep''04'!R[25]C"

any help would be appreciated
thanks
monika
Click to expand...


.
Click to expand...
 
G

Guest

pls ignore this further .. i resolved.
-----Original Message-----
hi tom,

thanks for the feebback..
i tried what u wrote but its not solving my purpose.
here is what i am getting in the cell:
='Sum Jun''04'!'Q29'+'Sum Jul''04'!'Q29'+'Sum
Aug''04'!'Q29'+'Sum Sep''04'!'Q29'

instead of Q29 i want C30...I used :
sAddr = ActiveCell.Offset(25, 0).Address(0, 0)
more i need to copy paste this value...and while doing so
the address of hte cell is not changing, which normally
does????
In all the cells the address is Q29!!!!!!

i want the address to chage since i am doing copy paste..
i hope i am clear...

thanks again
monika

-----Original Message-----
It means relative to the cell which contains the
Click to expand...
formula,
look down 25 rows.
So if I am in R1C1 (A1) R[1]C would be A2 - one row down, same column.

R[25]C would be A26

cells(ActiveCell.Row + 25,ActiveCell.Column).Address


sAddr = ActiveCell.Offset(25,0).Address(0,0)
ActiveCell.Formula = "='Sum Jun''04'!" & sAddr & "+" & _
"'Sum Jul''04'!" & sAddr & "+" & _
"'Sum Aug''04'!" & sAddr

--
Regards,
Tom Ogilvy



i want to replace "R[25]C" by the cells (row,column).address
(0,0) in the below formula. How can I do it..?

I am unable to interpret what "R[25]C" exactly means.

ActiveCell.FormulaR1C1 = _
"='Sum Jun''04'!R[25]C+'Sum Jul''04'!R[25] C+'Sum
Aug''04'!R[25]C+'Sum Sep''04'!R[25]C"

any help would be appreciated
thanks
monika
Click to expand...


.
Click to expand...
.
Click to expand...
 
T

Tom Ogilvy

If I have Q4 as the active cell, it produces

='Sum Jun''04'!Q29+'Sum Jul''04'!Q29+'Sum Aug''04'!Q29

and when I copy that, the cell references change with no problem. Works
fine for me.

--
Regards,
Tom Ogilvy

hi tom,

thanks for the feebback..
i tried what u wrote but its not solving my purpose.
here is what i am getting in the cell:
='Sum Jun''04'!'Q29'+'Sum Jul''04'!'Q29'+'Sum
Aug''04'!'Q29'+'Sum Sep''04'!'Q29'

instead of Q29 i want C30...I used :
sAddr = ActiveCell.Offset(25, 0).Address(0, 0)
more i need to copy paste this value...and while doing so
the address of hte cell is not changing, which normally
does????
In all the cells the address is Q29!!!!!!

i want the address to chage since i am doing copy paste..
i hope i am clear...

thanks again
monika

-----Original Message-----
It means relative to the cell which contains the formula, look down 25 rows.

So if I am in R1C1 (A1) R[1]C would be A2 - one row down, same column.

R[25]C would be A26

cells(ActiveCell.Row + 25,ActiveCell.Column).Address


sAddr = ActiveCell.Offset(25,0).Address(0,0)
ActiveCell.Formula = "='Sum Jun''04'!" & sAddr & "+" & _
"'Sum Jul''04'!" & sAddr & "+" & _
"'Sum Aug''04'!" & sAddr

--
Regards,
Tom Ogilvy



i want to replace "R[25]C" by the cells (row,column).address
(0,0) in the below formula. How can I do it..?

I am unable to interpret what "R[25]C" exactly means.

ActiveCell.FormulaR1C1 = _
"='Sum Jun''04'!R[25]C+'Sum Jul''04'!R[25]C+'Sum
Aug''04'!R[25]C+'Sum Sep''04'!R[25]C"

any help would be appreciated
thanks
monika
Click to expand...


.
Click to expand...
Click to expand...
 
Top