Rotating a square, very slow

[SPACKlick]

I'm working on using excel to program a board game (I know it's outside the usual function but it should be capable of it)

As part of the program I need to rotate a 15 by 15 tile. However most of the cells will be the same irrespective of the particular tile and orientation.
The centre 7x7 of the tile can either spin or not (i have no preference but not spinning it seems faster).
I have 2 codes that work but they're both very slow. Am I missing something obvious?

The tile I am rotating is in ("DL50:DZ64")
I am using the space ("EE50:ES64") to hold a spare copy while rotating

Faster code

Please Login or Register  to view this content.

simpler to change but slower Code

Please Login or Register  to view this content.

With the second code, StartTile and EndTile are only called twice or once respectively so they possibly don't need to be initiated as variables however that would lose some of its flexibility but even without that it takes several seconds to run. Am I missing something obvious?

[Pauleyb]

Why are you using the .Value(11)? That is what is bogging you down. I think just changing your lines to .Copy will achieve the same result and it seems faster on my system. e.g.

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

[SPACKlick]

Why are you using the .Value(11)?

In essence because Iwas taught never to use copy when you could use value, but I see now that value(11) is a lot heavier than value. That .copy method just took the time right down less than 1/3 what it was. Cheers.

I'll remove the Value(11) elsehwere as well, it should speed a lot of things up.

[Pauleyb]

Oh yes, generally what you say is true, but I think you see that is true for a pure .Value. Now, if you don't care about the formatting being copied, you should use just .value.

BTW, I did a quick speed comparison by running each solution 100 times. The .value(11) took 61.58 seconds, and the .copy took 3.36 seconds, so roughly 1/18.