Excel Dynamic Arrays

Dermot

New Member
Joined
Aug 11, 2006
Messages
24
I thought that was a great book, at a fantastically low price, thank you

i was especially delighted to find that any VBA macro can spill its results. For example, I was able to run an SQL query from a worksheet formula and spill the record set on the sheet, and write a Split function to break up a test string into separate cells. It’s magic (copied straight from Google Sheets, it seems, but magic all the same).

Anyway, thank you again for your book and the hard work that went into it.
 

Some videos you may like

Excel Facts

Create a chart in one keystroke
Select the data and press Alt+F1 to insert a default chart. You can change the default chart to any chart type

MARK858

MrExcel MVP
Joined
Nov 12, 2010
Messages
12,012
Office Version
365, 2010
Platform
Windows, Mobile
(copied straight from Google Sheets, it seems, but magic all the same)
Makes a change as most of Google sheets was copied from/based on Excel syntax :ROFLMAO:
 

Dermot

New Member
Joined
Aug 11, 2006
Messages
24
Yes, but Excel was copied directly from Lotus 1-2-3. That’s why TRUE = +1 in Excel and -1 in VBA, among other things.

you have no choice if you are taking on the market leader (as Excel was doing back then, and Google more recently) - you have to make it easy to switch by keeping the user interface and functions similar. It’s the same in video games.

But these “spill” functions were a long time overdue. As is decent automation, which is still severely lacking. You can use the ancient data tables to run multiple scenarios, but you can’t loop sheets within sheets. I had to write code to do it, and it proved exceptionally powerful, but there’s no reason why it couldn’t be built into Excel.
 

Dermot

New Member
Joined
Aug 11, 2006
Messages
24
But I love array macros, so much I can do with them now every macro can spill its results!
 

Forum statistics

Threads
1,089,220
Messages
5,406,927
Members
403,113
Latest member
ms_excel_recal_or_die

This Week's Hot Topics

Top