View Single Post
 
Old 08-29-2020, 06:03 AM
p45cal's Avatar
p45cal p45cal is online now Windows 10 Office 2019
Expert
 
Join Date: Apr 2014
Posts: 871
p45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond repute
Default

A start:
In Sheet1 of the attached, click the button.
In Sheet2 some negative numbers in the source data have been used.
In Sheet5 the same rusults as yours were obtained by using an alternative line of vba code starting vStart=… (see comments in the code).
Attached Files
File Type: xlsm msofficeforums45540plansv3.xlsm (34.4 KB, 9 views)
Reply With Quote