The powerful Excel spreadsheet app lets you create, view, edit, and share your files with others quickly and easily. It also lets you view and edit workbooks attached to email messages. Work in accounting, auditing, finance, or other fields, with anyone, anywhere with confidence.

I'm working on making an existing macro-enabled spreadsheet functional on Excel for Mac 2011. I have a function () that searches arrays for a specified value: Function IsInArray(stringToBeFound As String, arr As Variant) As Boolean IsInArray = (UBound(Filter(arr, stringToBeFound)) > -1) End Function It works perfectly in Excel 2013, but on Excel for Mac 2011, I receive the error: Runtime error '9': Subscript out of range I broke it apart and found that the UBound call is what's causing the error. I'd like to change as little as possible for maintainability. How can I fix this error for the Mac version? Thanks in advance for any replies!

Edit: @Siddharth Rout's solution is spot on, but since I was searching arrays within a loop, I had to modify the loop to reset the array between each iteration as follows (in case anyone else runs into the same issue!): ' --- START Reset Array for OS X --- Dim OS_X_Hack(99) As String For intIndex = 0 To 99 OS_X_Hack(intIndex) = Original(intIndex) Next Erase Original() ReDim Original(0 To 99) As String For intIndex = 0 To 99 Original(intIndex) = OS_X_Hack(intIndex) Next Erase OS_X_Hack() ' --- END Reset Array for OS X. Ok This is my observation. If you call the function once in a procedure then it will work fine. For Example Sub Sample() Dim a As Variant Dim s As String Dim strTemp As String s = 'CC' strTemp = 'A,B,C,D' a = Split(strTemp, ',') Debug.Print IsInArray(s, a) End Sub Function IsInArray(stringToBeFound As String, arr As Variant) As Boolean IsInArray = (UBound(Filter(arr, stringToBeFound)) >How to install vray for sketchup 2016 mac. -1) End Function However if you call it twice in the procedure then you will get an error Runtime error '9': Subscript out of range. Maybe it is an Excel 2011 Bug?

Sub Sample() Dim a As Variant Dim s As String Dim strTemp As String s = 'CC' strTemp = 'A,B,C,D' a = Split(strTemp, ',') Debug.Print IsInArray(s, a) s = 'A' Debug.Print IsInArray(s, a) End Sub Solution Recreate the array. See this example. Sub Sample() Dim a As Variant Dim s As String Dim strTemp As String s = 'CC' strTemp = 'A,B,C,D' a = Split(strTemp, ',') Debug.Print IsInArray(s, a) s = 'A' a = Split(strTemp, ',') Debug.Print IsInArray(s, a) End Sub Function IsInArray(stringToBeFound As String, arr As Variant) As Boolean IsInArray = (UBound(Filter(arr, stringToBeFound)) > -1) End Function.

Ethereality wrote: I visited the Apple Store, they turned me away (told me I 'had to schedule an appointment') and a sales associate recommended I uninstall and reinstall the software. Should I do this? I have the CDs in the original box, I think. Er, In time you may come to understand that there is much more expertise here in the discussions than in the Apple retail stores.

If you are patient, read carefully, and ask for clarification when you don't understand, you will generally be better off here than in the store. That's because the helpers here are specialists, whereas the store employees have to answer questions on all aspects of both hardware and software. To answer your question; no, I don't think you should reinstall.

Gul--iMac wrote: On my system Baseline adjustment only works on strings entered into a cell. Once in a cell, select the letter and then apply Baseline adjustment.

Note that the cell string changes but the value in the editing line still shows 'original' string. It's the normal behavior. The editing line isn't supposed to display attributes. It's designed for raw text only. Yvan KOENIG (VALLAURIS, France) samedi 30 avril 2011 12:32:27 Please: Search for questions similar to your own before submitting them to the community. It does not work in cells, either. I have just reproduced my problem, to give you more explicit description: • I create a new, blank spreadsheet from the Template Chooser.

• In the B2 (header) cell I enter 'H2O'. • In the B3 (header) cell I enter 'NaCl'. • I select the B2 cell and highlight '2' in the edit line. • I am unable to apply any superscript/subscript, neither from the 'A' superscript icon nor from Format -> Font -> Baseline; everything is greyed out. • I enter 'H2O' in F14, a random non-header cell, and again highlight '2'. Same inability to apply anything.

Mac studio fix reviews. As for the concealer, i probably should be using a lighter shade, but other than that, i'm also not loving the way it blends with the studio fix. Anyone have replacement suggestions for a concealer and/or a primer that they think works well in combo with the studio fix? Tl:dr what primer and concealer do you use with your mac studio fix? Use MAC Prep + Prime Fix+ to prolong the wear of your makeup and revitalize skin. Order now for free shipping on this hydrating makeup setting spray. As mentioned before, MAC Studio Fix Fluid Foundation liquid shade NW25 foundation is literally the best out of lots of foundations from different brands which I have used so far. I do not recommend it for daily use as it gives a heavy coverage.