vba FormulaR1C1

**.paul.** · 01-25-2009, 07:54 PM

how can i write a FormulaR1C1 in vba?
i want to set the formula in cell V2 to "=IF(SUM(B2:U2)>0,SUM(B2:U2),"")"

how can i do that in my macro?

question2: how do i filldown column V?

**shg** · 01-25-2009, 08:14 PM

That's not an R1C1 formula. If you want to enter the formula you have,

Please Login or Register  to view this content.

**rylo** · 01-25-2009, 08:16 PM

Hi

1)

Please Login or Register  to view this content.

2) If you can find the last relevant row, then put it into a variable. Assuming that column A will give you the last row then

Please Login or Register  to view this content.

rylo

**royUK** · 01-26-2009, 02:00 AM

How do you determine where to fill down to? This could be one way

Please Login or Register  to view this content.

**.paul.** · 01-26-2009, 11:57 AM

Originally Posted by shg

That's not an R1C1 formula. If you want to enter the formula you have,

Please Login or Register  to view this content.

yeah i know. i wanted to convert it to a R1C1 formula...

**.paul.** · 01-26-2009, 12:00 PM

how do i mark this thread SOLVED?

**shg** · 01-26-2009, 12:12 PM

yeah i know. i wanted to convert it to a R1C1 formula...

See VBA Help for the ConvertFormula method.

how do i mark this thread SOLVED?

Click the Edit button on your first post in the thread

Click Go Advanced, select [SOLVED] from the Prefix dropdown, then click Save Changes