Excel Blog
Copied!
Home
Options
4,183
JohnMacDougall on 10-08-2019 01:07 PM
3,012
Guy Hunkin on 10-02-2019 02:13 PM
3,202
Liam Bastick on 09-17-2019 08:56 AM
555K
Joe McDaid on 08-28-2019 09:00 AM
39.5K
Sam Radakovitz on 08-22-2019 09:00 AM
1,903
Ingeborg Hawighorst on 08-19-2019 01:31 PM
1,746
cuong on 07-30-2019 06:51 PM
10.3K
David Monroy on 06-03-2019 08:11 AM
12K
MS Excel Team on 05-29-2019 09:00 AM
5,771
Itai Goldstein on 05-19-2019 03:52 AM
1,859
cuong on 04-24-2019 01:17 PM
2,010
Theresa Estrada on 03-27-2019 05:05 PM
21.5K
David Monroy on 03-17-2019 09:01 PM
21.3K
Joe McDaid on 02-19-2019 11:27 PM
1,781
Theresa Estrada on 01-25-2019 02:18 PM
3,943
MS Excel Team on 12-05-2018 12:00 PM
2,596
Michael Molyneaux on 11-06-2018 02:54 PM
12.4K
Steve Kraynak on 10-22-2018 11:33 AM
3,500
MS Excel Team on 10-15-2018 01:05 PM
5,671
Maha Alam on 09-27-2018 04:39 PM
43.8K
Prash Shirolkar on 09-25-2018 06:00 AM
81.8K
Joe McDaid on 09-25-2018 06:00 AM
4,742
MS Excel Team on 09-18-2018 10:06 AM
3,236
Blake T Walsh on 09-14-2018 11:54 AM
7,897
Blake T Walsh on 08-23-2018 03:30 PM
24.1K
Blake T Walsh on 08-15-2018 12:11 PM
11.3K
Kasper Langmann on 08-07-2018 11:41 AM
3,724
Microsoft Excel on 07-26-2018 10:50 AM
8,588
Blake T Walsh on 07-17-2018 06:15 PM
9,543
Guy Hunkin on 07-16-2018 07:29 AM
Latest Comments
@lori_m ¡Esto no lo conocía!Y como diría Mafalda ¡La pucha!Sócrates:Este hombre, por una parte,cree que sabe algo,mientras que no sabe [nada].Por otra parte,yo, que igualmente no sé [nada],tampoco creo [saber algo].(:~}[>
1 Likes
@srdobrais - One way to create array variables dynamically is to call the xlfSetName and xlfEvaluate XLL functions (Ref: xlcall.h SDK header file) First execute this line from the immediate window:ExecuteExcel4Macro "register(""xlcall32"",""Excel4"",""2jpjpp#"",""XLCALL"")" Next define the named con...
0 Likes
¡Gracias @lori_m!Efectivamente, sería una buena idea pero …En algún lado leí o vi que hay forma de hacerlo, pero no recuerdo ni dónde ni cómo.Tenía que ver con una de las propiedades de las fórmulas matriciales para devolver un solo valor.¿Habrá alguien que lo sepa o recuerde?¡Lo siento yo no lo rec...
0 Likes
@srdobrais - Along the lines of your suggestion, I'd really like the ability to toggle on / off formula spilling. If spilling were turned off for a cell, the spill operator (#) would return a spilled array (as opposed to a range) and mousing over that cell would show a 'live preview' of the spilled ...
0 Likes
@JohnMacDougall "What a time saver! I only wish I had this years ago."You did have this in Excel since late 2010 as an Add-in called Fuzzy Lookuphttps://www.microsoft.com/en-in/download/details.aspx?id=15011 Since then it has had exactly 1 Update in (2014)This huge time save was neither promoted by ...
0 Likes