write formula into VBA

Av8tordude

Well-known Member
Joined
Oct 13, 2007
Messages
743
I want to use this formula in VBA. Any assistance is appreciated. Thanks

=SUMPRODUCT(SUBTOTAL(9,OFFSET(P15,ROW(P15:P427)-ROW(P15),0,1)),--(P15:P427 < 0))
 

Some videos you may like

Excel Facts

Did you know Excel offers Filter by Selection?
Add the AutoFilter icon to the Quick Access Toolbar. Select a cell containing Apple, click AutoFilter, and you will get all rows with Apple

Watch MrExcel Video

Forum statistics

Threads
1,089,970
Messages
5,411,577
Members
403,380
Latest member
ifog671

This Week's Hot Topics

Top