frade
05-10-2005, 01:52 PM
Hi,
Thanks for your help. Now, I continue my work but I have a new problem
when I divide a value of cell
Please have a look at my code (sheet2)
In a few word, it looks something like this
Dim valB As Long
valB = Worksheets("Sheet1").Range("B1").Value
sFormula = "((H" & i & "/& valB &"))"
Cells(i, "I").Value = Evaluate(sFormula)
But I receive a synthax error...:help
What could I do?
Thanks a lot
Best regards,
Fran?ois
Thanks for your help. Now, I continue my work but I have a new problem
when I divide a value of cell
Please have a look at my code (sheet2)
In a few word, it looks something like this
Dim valB As Long
valB = Worksheets("Sheet1").Range("B1").Value
sFormula = "((H" & i & "/& valB &"))"
Cells(i, "I").Value = Evaluate(sFormula)
But I receive a synthax error...:help
What could I do?
Thanks a lot
Best regards,
Fran?ois