Get instant live expert help on I need help with vba length of 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
I need these formulas in excel format (Length)2+ (Change in Height)2).5 10% is Design Standard (Length of Rake)*Catenary % Parameter of the Catenary C *(cosh ((L/2)/C)-1 C *(sinh ((Length of Rake)/C) Sum of Arc Lengths (Length of Rake * (Catenary) *0.67 Sum Areas of Deduction
Solved by A. H. in 20 mins
In cell H11, add a MAX function that will show the maximum call length minutes using the Call_Length named range and in cell H12, add an INDEX function that will use the Dept named range as the array associated with a MATCH function to determine the lookup array for the longest call referenced in H11 from the Call_Length named range with an exact match.
Solved by V. J. in 18 mins
What is the formula to count: Date of Membership: April 2015 Length of membership till today:....... (automatically update everyday) Date of Membership: 1 April 2015 Length of membership till today:....... (automatically update everyday) Date of Birth: 25 Dec 1970 Age today:........(automatically change)
Solved by I. F. in 22 mins