excel - Handling numbers larger than Long in VBA

Question

I am Currently trying to write some code in VBA to solve a problem from Project Euler. I have been trying to answer a question that requires you to find primes that can be divided into a number that will not fit in a long. Any suggestions as how to handle this problem?

I know I can split the number between two variables and I have done that for addition and subtraction but never division. Any help will be appreciated.

Answer 1

You can define a Decimal data type (12 Bytes), but only within a variant.

Dim i As Variant

i = CDec(i)