michiel.wordpress.com
Permutations with repetition using Excel | The Universe Divided
https://michiel.wordpress.com/2015/03/29/permutations-with-repetition-using-excel
Geekspeek By Michiel van der Blonk. Permutations with repetition using Excel. Posted March 29, 2015. Recently I have been trying to limit my use of VBA. It’s not that I was addicted and needed to go to VBA-rehab, on the contrary, I still love VBA till death do us part. But the thing is, every time someone opens an Excel sheet with VBA macros they are reminded of Excel’s vulnerability and the risks of macros. My latest endeavor was with. Go to the output sheet and look at the grid on the right. There ...
michiel.wordpress.com
Using named ranges and worksheet functions in Excel VBA | The Universe Divided
https://michiel.wordpress.com/2014/09/17/using-named-ranges-and-worksheet-functions-in-excel-vba
Geekspeek By Michiel van der Blonk. Using named ranges and worksheet functions in Excel VBA. Posted September 17, 2014. A couple of days ago I saw something in an article on StackOverflow, that blew my mind. I can’t find the article anymore, but I do remember what this one neat trick was, that will for ever change your VBA. It’s called a named range, and I found out I had always been doing it wrong. So have you, most likely. Have you ever written something like this? Make a new sheet. I am a lazy teacher...
michiel.wordpress.com
How to fix the document map in MS Word 2007 | The Universe Divided
https://michiel.wordpress.com/2013/08/30/how-to-fix-the-document-map-in-ms-word-2007
Geekspeek By Michiel van der Blonk. How to fix the document map in MS Word 2007. Posted August 30, 2013. That horrendous, horrible, horrific horror! It never does what I ask it to, it never shows what I tell it to show, it constantly messes itself up beyond recognition. It’s like a crazy guy beating himself up, I keep thinking of Fight Club. The first rule of Document Map is you don’t talk about Document Map. And yet, I am going to talk about it. What are its problems? The map is not updated. Grrrrr.
michiel.wordpress.com
10 worst Microsoft Excel practices | The Universe Divided
https://michiel.wordpress.com/2009/04/05/10-worst-microsoft-excel-practices
Geekspeek By Michiel van der Blonk. 10 worst Microsoft Excel practices. Posted April 5, 2009. So here it goes, starting with the worst:. 1 Using cross tabs. Cross tabs (contingency tables, like e.g. years on the left column and months on the top row) are nice for a visual report, but the data cannot be used in any other way. If you’ve read my recent article about the TableToListConverter. You know why. Excel is an excellent analyzer of data, as long as this data is organized in rows (. Has an alias of.
michiel.wordpress.com
Fantasy Selling | The Universe Divided
https://michiel.wordpress.com/2013/08/29/fantasy-selling
Geekspeek By Michiel van der Blonk. Posted August 29, 2013. Filed under: Personal stuff. The earth is FLAT! The earth is flat. Goal: sell the idea that the earth is in fact flat. Script: “Hey, you know the whole thing about the earth being a globe is in fact a hoax? Laquo; A physics model of a physics model. How to fix the document map in MS Word 2007 ». 3 comments so far. On January 1, 2015. Great – love the thinking here Michiel. Ie Some people are totally fine with it, but – others resist, so &#...
michiel.wordpress.com
Cube | The Universe Divided
https://michiel.wordpress.com/rubiks-cube-solution
Geekspeek By Michiel van der Blonk. I do a lot of things, but most of all my main hobby is the Rubik’s cube. Here are some links to things I have either made or find interesting. My Rubik’s cube solution is a popular one online. My site – www.vanderblonk.com. Algorithms Database – alglist.ning.com –. YY method – simple Rubik’s cube solving method. 8211; a tutorial for solving the cube. Dan Harris – UK #1. Speedcubing.com – The source. Werner Randelshofer – Java Cubes. Leave a Reply Cancel reply.
michiel.wordpress.com
The selection contains multiple data values… Merging cells in Excel. | The Universe Divided
https://michiel.wordpress.com/2013/11/03/the-selection-contains-multiple-data-values-merging-cells-in-excel
Geekspeek By Michiel van der Blonk. The selection contains multiple data values… Merging cells in Excel. Posted November 3, 2013. This is a super power. Feature I have always missed in Excel: the ability to join the content of cells without losing any data. Sorry, what’s that? Yes, I know about the ‘merge’ option. It’s lame! So, I decided to ‘deal with it’ and I present here several macros for your pleasure and entertainment that will solve this once and for all. Merging, Joining and Combining. In some o...