Functions / VBA Coding - Extended viewing distance

Yesterday I decided to change the pathfinding code. It works a little bit slower, but... it's better!

I think that I will be able to make it works faster. Anyway, that's not what I wanted to write about in this post!
I probably had too much time today and spent few hours writing new formulas and translating them to VBA. The result is longer viewing range: +1 cells row in each direction. I needed to upgrade it in order to make enemies visible from at least a little bit longer distances.

Range before update

Range after update

VBA Coding - Pathfinding

I had some time and decided to create a small addition to my Excel game, Cells Dungeon.

 'Cells' had a little bit crappy code implemented: enemies were walking in random directions and weren't chasing the player. That wasn't even close to a good solution, so I had to create something better.
It is still in a test phase and will probably require some performance fixes, but... I will have time to do it somewhere in the future!

Here's a small preview of how it works now:

General info - Cells Dungeon - Game in Excel?!

What the hell is Cells Dungeon?!

Once upon a time, there was a guy who had to work with excel and he really liked it. He liked it so much that he decided to use some of his imagination and some VBA knowledge to create something different.

The guy always wanted to create pc games. Unfortunately, he didn't know where to start. Then he was forced to learn some basics of VBA and... that's how everything started! 

Hours of thinking, coding, debugging, frustration and swearing and... BOOM! First playable version of rouglike game made in MS Excel was ready!

Features:

• randomly generated levels (20k cells large; code needs little improvement)
• lots of randomly generated weapons, helmets, armors, shields
• SKILLS, SKILLPOINTS and LEVELS (yay!)
• possibility of getting drunk and addicted to alkohol
• possibility of becoming a vampire
• hand drawn images of enemies (thanks to Retta!)

and many other stuff!