View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Paul Mathews Paul Mathews is offline
external usenet poster
 
Posts: 84
Default 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