application defined error
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 |
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 . |
application defined error
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 |
All times are GMT +1. The time now is 01:37 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com