By using expertatexcel.com you agree to our cookie policy, We and our partners operate globally and use cookies, for multiple purposes

Become an Σxpert at Σxcel.com

 


Standard VBA/Excel (20 of 1182)

(Clear Filter = *array*)

Array -start with "a", array function
reference value in an array aSuffixes(i)
InArray(array,value) - determines if value is in the array - udf
Ubound(array) - finds the upper bound of an array
LBound(array) - returns the lower bound of an array
Split(string,"value") - converts string into an array
Sheets(Array("sheet1","sheet2").copy
InArray(array, the_value)
LoadArray 🔝
LoadArray(workbookname, Sheetname, header) 🔝
ByteArrayToString - internet
stringtobytearray - internet
PivotFields("field_name").Subtotals = Array(False, False, ...)
IsArrayEmpty - udf
Activesheet.Shapes.Range(Array("Button 1")).Select
Selection.OnAction = "TOC1.AddTocSheet" ' Select the shape first via ActiveSheet.Shapes.Range(Array("Button 1")).Select
Array(string, string, ....) - Converts a list of strings to an array
Subscript out of range
Large Arrays - Interview Question
Arrays vs. Collections