Hi Guys

New to this board and hope you can help.

I have an array which is declared as type long but when presented with variables a = 555 and b = 555555 the following multiplication cannot be performed.

Dim Var as long

Var = a * b

I get a runtime error 6 'overflow' message.

This is a simple example which I tried when my actual code did not work.

Any help appreciated.

Thanks