Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Function FindRng(StartRng As String, EndRng As String) As Variant
- Dim TopOfRange As Single
- Dim BottomOfRange As Single
- TopOfRange = WorksheetFunction.Match(StartRng, Sheets("InfCom").Range("B:B"), 0)
- BottomOfRange = WorksheetFunction.Match(EndRng, Sheets("InfCom").Range("B:B"), 0)
- FindRng = Range(Sheets("InfCom").Cells(TopOfRange, 2), Sheets("InfCom").Cells(BottomOfRange, 2))
- End Function
- Function subsetPBPC(rngReturn As Range, LookupValueH As Variant, TopOfRange As String, BottomOfRange As String, LookupValueV As Variant) As Variant
- subsetPBPC = sPBPC(rngReturn, LookupValueH, FindRng(TopOfRange, BottomOfRange), LookupValueV)
- End Function
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement