View Single Post
  #29   Report Post  
Posted to microsoft.public.excel.programming
GS[_2_] GS[_2_] is offline
external usenet poster
 
Posts: 3,514
Default Modify this Array

FYI...

The Split() function has been around since VBA6 as part of the new
features for working with arrays. Two others were included: Join(),
Filter().

If your home version of Acad doesn't like this function, it suggests
you have a really old version. You might be able to install VBA6 over
the older version. Current version now is VBA7 to work with x64 apps.

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion