Learn how to create Dynamic Array Functions in Excel VBA. We'll create a UDF (User Defined Function) called SPLITNAMES that will return a dynamic array with first, middle & last names separated.

Full playlist https://youtube.com/playlist?list=PLv9Pf9aNgemv70hH_CbTMV1QVL5VkgJYS

This tutorial will cover:
- UBound function
- LBound function
- Split function
- Dynamic arrays in VBA
- Debugging

#excel #vba #dynamicarrays