adding dynamic formula inside loop to insert into offset cell

**smartphreak** · 11-09-2011, 02:17 AM

Hi all,

not sure if my tiutle made sense...

but this is what I have

ActiveCell.Offset(nRow, 1).Formula = "=sum(D" & nRow + 3 "+ H" & nRow + 3")"

This sits inside a loop where nRow is increase by 1 each loop.

I am looking to have the following output:

C4: =sum(D4,H4)
C5: =sum(D5,H5)

etc...

the syntax is throwing out an error... any ideas?

Thanks a million
smartphreak

**TMS** · 11-09-2011, 02:42 AM

Maybe

Please Login or Register  to view this content.

Regards

**mikerickson** · 11-09-2011, 02:45 AM

Please Login or Register  to view this content.

**smartphreak** · 11-09-2011, 02:57 AM

Thanks....

could not see the wood for the trees....

adding dynamic formula inside loop to insert into offset cell

LinkBack

Thread Tools

Rate This Thread

Display

adding dynamic formula inside loop to insert into offset cell

Re: adding dynamic formula inside loop to insert into offset cell

Re: adding dynamic formula inside loop to insert into offset cell

Re: adding dynamic formula inside loop to insert into offset cell

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions