Forum Discussion
Solved
Data validation using VSTACK with dynamic arrays
I create two distinct dynamic arrays (e.g. dynArray1=OFFSET(rangeName1,0,0,COUNTA(rangeName1),1). Either of the two dynamic arrays can be used successfully as the source for data validation. Howeve...
S_Cubed You're not missing anything, but DV expects a range formula that returns a range. Dynamic array functions don't work. What you need to do is write the VSTACK formula, let's say in K1. Then, point the DV list to =K1#
That should work.
Peter,
I've been holding my breath for Visual Studio capabilities to replace VBA.
I've been holding my breath for Visual Studio capabilities to replace VBA.
After retiring, I set out to learn Visual Basic and the .Net environment in anticipation of it replacing VBA. I got that totally wrong and would have been better off focussing on the Web technologies.
Now TypeScript appears to be the way forward is assume there is some room for Visual Studio. Unfortunately I think I would need business editions of 365 to be able to use PowerAutomate etc.