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?
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?
Last edited by .paul.; 01-26-2009 at 12:27 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks