Error message of CLng

[gordonf35]

Hello,

It may sound really really stupid but I have no idea why CLng does not accept a long string which is a number. I have tried it for the whole night and still have no idea of what's going on

This is my code:

abc = CLng("111111111111111111111")

And it always come with an error. Thanks very much for helping me.

Kind Regards,

Gordon

[JosephP]

the largest value of a long is 2,147,483,647 so your value is a little bit big ;-)
you need a Double

[tigeravatar]

Excel can't handle numbers larger than 15 digits. You could get that line to work with CDbl instead of CLng, but the resulting number would be 111111111111111000000 because Excel will handle the first 15 digits, and everything after that gets dropped.

[tigeravatar]

As an example:

Sub tst()
    
    Dim abc As Double
    abc = CDbl("111111111111111111111")
    MsgBox Format(abc, "0")
    
End Sub

Run that code and you'll see what I mean

[gordonf35]

Many thanks guys!! I thought long is really "long". So I thought it should hold more digits than integer.

Anyway, many thanks!!!!!



Good night,

Gordon

[JosephP]

it does - Long is Long Integer. a regular integer only goes up to 32767

[gordonf35]

So what does the largest number that a variant hold?

[gordonf35]

Yes, I thought the integer usually take more values than variant

[JosephP]

a variant can hold anything including objects. the largest value it can hold is a double so 1.79769313486232E308

[gordonf35]

Thanks JosephP!