Thread: a string to an integer in microsoft.public.excel.programming

  they all had len=2 and nothing looked out of the ordinary. "Sam Wilson" wrote: > msgbox len(str) & " """ & str & """" > > Sorry, my mistake. Change str for whatever string it is you're trying to > convert. >  

  msgbox len(str) & " """ & str & """" Sorry, my mistake. Change str for whatever string it is you're trying to convert. Sam "Philosophaie" wrote: > I typed verbatum: > > msgbox len(str) * " """ & str & """"...

  Also String is an intrinsic function in VB! Use Option Explicit at the top of your module and make sure you dim all of your variables using names that are not intrinsic functions. "Philosophaie" wrote: > I have a string: > > string(3) = "543" > > I try to change it to an integer: > > int = cint(string(3)) > > It gives me a 'Type...

  Don't use String and Int as variable names. String is a VBA function and data type. Int is a VBA function. Dim myString(1 To 3) As String Dim myInt As Long myString(3) = "543" myInt = CInt(myString(3)) Personally, I wouldn't use "as integer" or cInt(). I'd use "As long" and clng(). Philosophaie wrote: > > I have a string: > > string(3)...