converting a double to a long

[vbanative]

I am trying to convert a double to a long using:

CLng(test)

However, when I run it I get an overflow error. The reason I need to convert 'test' to a long is because I want to use the And operator in the following way:

truth = (test and &H1F)

Where truth is a long. Any suggestions?

 

[JoeMo]

I am trying to convert a double to a long using:

CLng(test)

However, when I run it I get an overflow error. The reason I need to convert 'test' to a long is because I want to use the And operator in the following way:

truth = (test and &H1F)

Where truth is a long. Any suggestions?

Maybe round it to 0 decimal places:
test = WorksheetFunction.Round(test, 0)

 

[Rick Rothstein]

I am trying to convert a double to a long using:

CLng(test)

However, when I run it I get an overflow error. The reason I need to convert 'test' to a long is because I want to use the And operator in the following way:

truth = (test and &H1F)

Where truth is a long. Any suggestions?

What is the Double value that is giving you the problem?