Hi

I am trying to put value in a cell..which is a sum of 3
cells of 3 sheets
Here is my statement:
Cells(gfRowMain, rngGfOne.Column + Mloop).value= "=" &
finMatchVar
i have also tried :
ActiveCell.FormulaR1C1 = "=" & finMatchVar
in both cases i am getting object defined error.

I get finMatchVar variable as following on printing it:
'[Copy of Actual_Underutilisation_Assembly_0404.xls]
summary 0304'!R34C3+'[Underutilisation_Assembly_0405.xls]
Sum May'04'!R32C3+'[Underutilisation_Assembly_0405.xls]Sum
May'04'!R32C3

what mistake i am doing?
thanks a lot in advance
Monika

-----Original Message-----
Hi

I am trying to put value in a cell..which is a sum of 3
cells of 3 sheets
Here is my statement:
Cells(gfRowMain, rngGfOne.Column + Mloop).value= "=" &
finMatchVar
i have also tried :
ActiveCell.FormulaR1C1 = "=" & finMatchVar
in both cases i am getting object defined error.

I get finMatchVar variable as following on printing it:
'[Copy of Actual_Underutilisation_Assembly_0404.xls]
summary 0304'!R34C3+'[Underutilisation_Assembly_0405.xls]
Sum May'04'!R32C3+'[Underutilisation_Assembly_0405.xls]
Sum
May'04'!R32C3

what mistake i am doing?
thanks a lot in advance
Monika
.

Monika,

Assuming that all the variables are valid values, all you need is

Cells(gfRowMain, rngGfOne.Column + Mloop).value = finMatchVar

put some debug statements in and see what you get for all of the variables.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

wrote in message
...
Hi

I am trying to put value in a cell..which is a sum of 3
cells of 3 sheets
Here is my statement:
Cells(gfRowMain, rngGfOne.Column + Mloop).value= "=" &
finMatchVar
i have also tried :
ActiveCell.FormulaR1C1 = "=" & finMatchVar
in both cases i am getting object defined error.

I get finMatchVar variable as following on printing it:
'[Copy of Actual_Underutilisation_Assembly_0404.xls]
summary 0304'!R34C3+'[Underutilisation_Assembly_0405.xls]
Sum May'04'!R32C3+'[Underutilisation_Assembly_0405.xls]Sum
May'04'!R32C3

what mistake i am doing?
thanks a lot in advance
Monika