September 21

Excel 3d Maze Update!

3  comments

Pedro Wave made a few updates to the 3d Maze spreadsheet that I really love.
image
Please download the latest version to see them for yourself. Also, be sure to checkout his blog.
maze-example.xlsm


Tags


You may also like

51: Oz du Soleil & the Global Excel Summit 2021

51: Oz du Soleil & the Global Excel Summit 2021

Global Excel Summit 2021

Global Excel Summit 2021
  • Great articles! I have learnt a lot from your approach, many thanks. I have a question for you: Rapid updating of cells is very important in game development, what are your thoughts on the quickest way to update a cell’s format based on rapidly changing variables: Cell conditional formatting, use vba to format interior, use vba to apply different cell styles. Your thoughts would be greatly appreciated!

    • Hmmm. I mean, I’m in the habit of trying everything and then comparing the results. From the outset, the quickest way would be to change a cell’s interior. In fact, if you have many cells to modify, the even quicker way is to change as many cells as you can with on action rather than iterating through each cell in the list.
      i.e. don’t do this:
      For each cell in SomeRange
      cell.interior…
      next
      rather, do this:
      SomeRange.Interior…
      Styles are heavyweight, so they’re not my favorite option. Conditional formatting changes trigger recalculations, so in theory, they should be slowest and least preferable. That said, if you’re looking for speed, sometimes the bottleneck is because of how the spreadsheet is laid and not due to individual actions (such as triggering recalcs).

      • Thanks Jordan, I like the range.interior option, especially in conjunction with SomeRange.SpecialCells(xlCellType ….).Interior. Much appreciated, Marty

  • {"email":"Email address invalid","url":"Website address invalid","required":"Required field missing"}

    Free Power User Quick Guide

    Discover The BEST Ways To Use Lookups And Conditional Calculations Quickly And Easily With This Reference Guide -- You Won’t Want This To Leave Your Side

    With so many ways to use Excel, it can be difficult to memorize all of the key functions, calculations, and techniques you can employ to meet your goal: simply get the job done.

    >