Forum Discussion
Solved
VBA CSE array UDF and dynamic arrays
CSE = Ctr+Shift+Enter UDF = User Defined Function In a row, I have a some inputs of a VBA CSE row array UDF located in the same row. The array function is copied down. The inputs of each copy are in...
- Depends on how you pass the large range. If the declaration is of type Range or Variant, you are just passing an object reference. Whether the range is one cell or 10000 makes no difference for the time it takes to pass the object pointer.
Depends on how you pass the large range. If the declaration is of type Range or Variant, you are just passing an object reference. Whether the range is one cell or 10000 makes no difference for the time it takes to pass the object pointer.