Hi all, I'm using arrays in VBA for my first time, and I can't find a lot of info about them in the help files. I even had to accidentally stumble across UBound to find out the array's size. Does VBA have built in functions for:

push: add data to end of array
pop: remove data from end
unshift: data to front
shift: remove data from front
insert: add data in middle and push the rest out to fit
inArray: return the index where the data was found, if it's in the array

Also, is it possible to create a const array?

Thanks!