application defined error-pls ignore this
-----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
.
|