split not working

O

OceanView

Okay, maybe I've just benn staring at it too long. Why doesn't this work?
Doesn't matter whether I put a space after the comma or not. End result is
the entire string winds in s_array(0). Any clue?

Dim s_array As Variant
dim s_types as string
s_types = "18FC,36FC, 72FC"
s_array = Split(s_types, ",")
 
O

OceanView

Okay, maybe I've just benn staring at it too long. Why doesn't this
work? Doesn't matter whether I put a space after the comma or not. End
result is the entire string winds in s_array(0). Any clue?

Dim s_array As Variant
dim s_types as string
s_types = "18FC,36FC, 72FC"
s_array = Split(s_types, ",")
Click to expand...

Never mind. figured it out. needed vba.split. Not sure what I was calling!
 
J

Jonathan West

OceanView said:
Never mind. figured it out. needed vba.split. Not sure what I was
calling!
Click to expand...

I guess you have a function called Split in your project? Or possibly you
have set a reference to another library in Tools References, and that
library which has a Split function in it.
 
Top