Performance test regarding variable declarations. Does Variable declaration matters nowadays?

[Luthius]

Guys
I was looking forward a Speed Test or Performance test where is possible measure a code running with declared variables and other without variable declaration.

I saw a lot of discussions about this subject and it always goes to a Best Practice point of view rather then "performance" or error management.
Okay, in my projects I always declare the variables and try my best to proper set the most memory optimized type as possible.
Even some object type I guess is NOT "mandatory" because the VBE "guess" and compile it.

If someone has some speed test or performance test or something that can share it, where shows that it goes beyond best practices, I mean, declare variables really matters for the computer's capacity nowadays (memory, processor, etc.)

 

[MARK858]

Not really speed wise unless you have huge data , it is just on a very rare occasion VBA can misinterpret what you want if the value changes from one data type to another (say your initial value was a Long and then you started using Decimals).
The main advantage of declaring your variables is you can use Option Explicit to pick up on typo's.

 

[Luthius]

In other words doesn't matter declaring the variables or not. For coding sake I mean.

But I'm curious because variant types demand more usage of memory, so it can jeopardize the speed, right?

 

[MARK858]

It affects the speed but it is a case of how noticeable it is. As I stated the main advantage of declaring them these days is debugging.