I'd like to change as little as possible for maintainability. I broke it apart and found that the UBound call is what's causing the error. It works perfectly in Excel 2013, but on Excel for Mac 2011, I receive the error: Runtime error '9': Subscript out of range IsInArray = (UBound(Filter(arr, stringToBeFound)) > -1) I have a function ( Source) that searches arrays for a specified value: Function IsInArray(stringToBeFound As String, arr As Variant) As Boolean I'm working on making an existing macro-enabled spreadsheet functional on Excel for Mac 2011.
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |