LinkBack URL
About LinkBacks
how can we multiply ONLY FULL CELLS in active row ( interval B- E columns) by a macro
for example
B6 C6 D6 E6
5 6 EMPTY 2 =60 (result)
how can we multiply ONLY FULL CELLS in active row ( interval B- E columns) by a macro
for example
B6 C6 D6 E6
5 6 EMPTY 2 =60 (result)
i asked and i found myself
ActiveCell.FormulaR1C1 = "=if(ISERROR(PRODUCT(RC[-2],RC[-3])),"""",ROUNDUP(PRODUCT(RC[-2],RC[-3]),0))"
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks