excel - Declare a variable as Decimal

Question

I'm optimizing a macro in VBA which had none of the data types declared, so everything was clumsily treated by the compiler as a variant. I'm dealing with scientific measurements, so I need precision.

How do I declare Dim decAsdf as Decimal (not like that but the proper way)?

Answer 1

You can't declare a variable as Decimal - you have to use Variant (you can use CDec to populate it with a Decimal type though).