Charlotte Foust
charlotte.foust at gmail.com
Fri Apr 22 10:12:20 CDT 2011
What is the (0) for? You have to declare the variable as a variant because the value returned from Split is an array. Charlotte Foust On Fri, Apr 22, 2011 at 7:57 AM, philippe pons <phpons at gmail.com> wrote: > Dim Test() As Variant > > Philippe > > 2011/4/22 Kaup, Chester <Chester_Kaup at kindermorgan.com> > >> I am trying to use the split command on the following string >> >> " 0.000 243.729 - >> 61.495 -" >> >> I have a dim statements as follows >> Dim LineText As String >> Dim Test() As String >> >> The split statement is as follows >> Test = Split(LineText)(0) >> >> No matter how I dim Test() I get an error message of >> Run Time Error 13 >> Type Mismatch >> >> This seems like it should be real simple but I am obviously missing >> something. >> >> Thanks. >> >> >> >> >> Chester Kaup >> Engineering Technician >> Kinder Morgan CO2 Company, LLP >> Office (432) 688-3797 >> FAX (432) 688-3799 >> >> >> No trees were killed in the sending of this message. However a large number >> of electrons were terribly inconvenienced. >> >> >> -- >> AccessD mailing list >> AccessD at databaseadvisors.com >> http://databaseadvisors.com/mailman/listinfo/accessd >> Website: http://www.databaseadvisors.com >> > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com >