Putting formula in cells from a loop

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Andreww - 13 Feb 2007 11:36 GMT

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

Reply to this Message

Peter T - 13 Feb 2007 11:55 GMT

Hi Andrew,

change

> = "=sum(""A""&ltrim(str(ii)))"

to
= "=sum(A" & Trim(Str(ii)) & ")"

or simply
= "=sum(A" & ii & ")"

you don't need the other Trim(Str(ii)) either

Regards,
Peter T

> Hi - I want to put formulae in cells in my worksheet based on
> itterating values.
[quoted text clipped - 22 lines]
>
> Andrew

Reply to this Message