Hi - I want to put formulae in cells in my worksheet based on
itterating values.

For instance:

=sum("A2")
=sum("A3")
=sum("A4")
=sum("A5")

The way I thought to do it was from this loop

For ii = 1 To 5
Sheets("detail").Range("E" & Trim(Str(ii))).Formula =
"=sum(""A""&ltrim(str(ii)))"
Next ii

Whatever I try I get #NAME? in the cells on the worksheet.

Tried changing quotes, putting ampersands in etc.

Any ideas?

Thanks

Andrew