Having done my time in Excel and VBA, I can say as soon as you need to use VBA in Excel you're at the limit of what Excel can do.
It's a fantastic tool for visualising data, but as soon as you need to pass multiple data sets through an algo - you reach the limit of not only Excel, but the concept of visualising the entire working of an algorithm.
Having done my time in Excel and VBA, I can say as soon as you need to use VBA in Excel you're at the limit of what Excel can do.
It's a fantastic tool for visualising data, but as soon as you need to pass multiple data sets through an algo - you reach the limit of not only Excel, but the concept of visualising the entire working of an algorithm.
Basically, it can't iterate (well).