Get instant live expert help on I need help with vba const array
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”
Here are some problems that our users have asked and received explanations on
I'm trying to make a VBA function with two arrays; the first array has the numeric values while the second array has the names. The function will find the value in the first array that is the largest and return the corresponding name (from the second array).
Solved by D. Y. in 11 mins
Can the counter variable for an Excel VBA be an array element? [ie, For A(N) = 1 to 9]
Solved by G. A. in 24 mins
Hey I need help with VBA. The first functions that you will create are helper functions that can be used by otherfunctions. Function FindMax(valueArray, nameArray) As String This function takes in two arrays; the first array has the numeric values while thesecond array has the names. The function will find the value in the first array that isthe largest and return the corresponding name (from the second array). For instance, if the valueArray = (10, 20, 5, 9) and nameArray is (House, Chair, Table, Book). The function will return Chair.
Solved by F. A. in 24 mins
create stack bar charts for 3 tabs: Const LTV Graph, CRE LTV Graph and Multi LTV Graph using table with data provided. Also, in C8 in aforementioned tabs modify formula not to count O (zeros).
Solved by C. E. in 29 mins
I have a series of functions that involve averaging the values surrounding the minimum value of an array, and for each array the point in the array where the minimum can vary. Is there a function or combination of functions that will allow me to (for example) average(location(min(array)+2):location(min(array)-2))? A method to read out variable cell locations?
Solved by B. B. in 13 mins