ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   variant to long? (https://www.excelbanter.com/excel-programming/363936-variant-long.html)

James Cornthwaite

variant to long?
 
does anybody know of a function to convert a variant to a long?

i know "=cint(variant)" works for an integer
is there a long equivalent?

James



Paul Mathews

variant to long?
 
Try "clng"

"James Cornthwaite" wrote:

does anybody know of a function to convert a variant to a long?

i know "=cint(variant)" works for an integer
is there a long equivalent?

James





All times are GMT +1. The time now is 04:48 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com