Some added thoughts.

What error are you getting.

is row a number between 1 and 65536
is col a number between 1 and 256 or a single letter between a and z or a
double letter between AA and IV
Is SheetDestination a string variable having a value that corresponds to an
existing sheet name. Is that Sheet a worksheet?

--
Regards,
Tom Ogilvy


"Mike VB" wrote in message
...
Hello
I've an error:

Sheets(SheetDestination).Cells(row, col).Formula =
"=(19981,1882918624*452)/19981,1882918624"

En fait ma ligne de code exact est:
Sheets(SheetDestination).Cells(row, col).Formula = _
"=(" & Sheets(SheetSource).Cells(row, col).Value & _
"*" & Base & ") / " & ValEnt


Regrads